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 |
|
GavinS
Starting Member
14 Posts |
 Posted - 2005-08-18 : 03:20:49
|
| Hello Everyone,I have had a query from a work colleague who is working offsite who has set up a view on a server. When they run the code created for the view it seems to run fine but when they then try to access the view the following error is shown.Server: Msg 8114, Level 16, State 1, Procedure edi, Line 7Error converting data type DBTYPE_DBTIMESTAMP to datetime.The view is a simple set of selects with UNION ALL seperating them. Any ideas? From what I can see all the columns in the union are the same format in the same order.Thanks.Gavin |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-18 : 03:25:32
|
| Post the table structure and Create View queryAre you using SQL Server 2000?MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
DateTime Error