Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-25 : 09:49:15
|
| Le writes "I have 3 view tables, assuming they are vwTable1, vwTable2 and vwTable3. The vwTable3 is derived from the union of the vwTable1, and vwTable2.I get "Syntax error converting the varchar value 'ALL ' to a column of data type int." error message when I issue the following statement in the Sql Querry Analyzer pannel: 'select * from vwTable3'what do I do wrong?Many thanks in advance...:)" |
|
|
Crespo
85 Posts |
Posted - 2002-10-25 : 10:25:00
|
| Could you post your complete code. Maybe we can help you more to solve the problem.Best Regards.Crespo.Hewitt Bacon & WoodrowEpsomSurreyUnited Kingdom |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-10-25 : 19:56:49
|
| When you're doing a UNION, the columns that are returned from every SELECT statement in the UNION have to by the same data type and you have to have the same number of columns returned by each. If you want to override the data type limitation, you can insert your own explicity CONVERT command to make them all the same data type in the result set. |
|
|
|
|
|
|
get error message when selecting all records from a view