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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-12-21 : 14:21:24
|
| I have a select with several case statement in it. When I tried to make it into a View I got this:The Query Designer does not support the CASE SQL construct...But the data grid below did return the same data set as in the QA, and it could save the view. I do need to have the case in there if it is possible. Thanks! |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2005-12-21 : 15:16:36
|
| Don't use the view designer in EM. It's buggy insofar as it can't deal graphically with CASE as you've found out. However, you should be able to save the query and modify it then with QA.--Frank KalisMicrosoft SQL Server MVPhttp://www.insidesql.deHeute schon gebloggt? http://www.insidesql.de/blogs |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-12-21 : 16:13:34
|
quote:
Originally posted by Hommer
I have a select with several case statement in it. When I tried to make it into a View I got this:The Query Designer does not support the CASE SQL construct...But the data grid below did return the same data set as in the QA, and it wouldn't save the view. I do need to have the case in there if it is possible. Thanks!
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-22 : 02:36:16
|
quote:
Originally posted by Hommer
quote:
Originally posted by Hommer
I have a select with several case statement in it. When I tried to make it into a View I got this:The Query Designer does not support the CASE SQL construct...But the data grid below did return the same data set as in the QA, and it wouldn't save the view. I do need to have the case in there if it is possible. Thanks!
Hommer, Did you get solution from Frank's reply?It seems that you quote the question againMadhivananFailing to plan is Planning to fail |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-12-22 : 10:08:59
|
| Yes, I got my question answered.Also, I did not remember I re-post the second one. It is an accident. Sorry.And as always, thanks! |
|
|
|
|
|
|
Create view does not allow Case?