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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Create view does not allow Case?

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 Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs
Go to Top of Page

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!

Go to Top of Page

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 again

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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!
Go to Top of Page
   

- Advertisement -