The query designer does not support the CASE SQL construct, when using Case in a view 
Author Message
 The query designer does not support the CASE SQL construct, when using Case in a view

I have a view and I want to make a new column based upon the values in
another column.

Here is the IIF representaton of what I was trying to do:
IIF(value1 = 'Y' or value2='N',-1,0) as Applicable

It would not work.  Then I think I read that I can't use IIF in my View, so
I tried using the case statement:

case when value1 = 'Y' or value1 = 'N' then -1 else 0 end as Applicable

But I get the "The query designer does not support the CASE SQL construct"
error

Will someone tell me how do I do this?

Thanks

-C



Sat, 25 Oct 2003 03:14:54 GMT
 The query designer does not support the CASE SQL construct, when using Case in a view

See my reply in .server. Please don't multipost.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.


Quote:
> I have a view and I want to make a new column based upon the values in
> another column.

> Here is the IIF representaton of what I was trying to do:
> IIF(value1 = 'Y' or value2='N',-1,0) as Applicable

> It would not work.  Then I think I read that I can't use IIF in my View,
so
> I tried using the case statement:

> case when value1 = 'Y' or value1 = 'N' then -1 else 0 end as Applicable

> But I get the "The query designer does not support the CASE SQL construct"
> error

> Will someone tell me how do I do this?

> Thanks

> -C



Sat, 25 Oct 2003 03:35:34 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. QD does not support CASE Sql Construct

2. SQL EM - Creating View, CASE not supported ?!

3. PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression

4. Case Sensitive and not so Case Sensitive

5. Case sensitvie query on case insensitive database.

6. Problem : Doing case-insensitive queries...

7. View doesn't support CASE function?

8. View in 7.0 doesn't support Case statement

9. mixed case query on SQL Server 7.0 using LIKE

10. using lower case characters for table names in queries (SQL 7.0)

11. CASE is not supported

12. CASE with MSDE not supported????


 
Powered by phpBB® Forum Software