The View does not support Case Structure

[accessman2]

SELECT Date, [Check] = CASE WHEN [Elec] = 'A' THEN 'T' ELSE 'Exe' END
FROM Employees

The View query does not support Case statement. Whereas Query Analyzer support it. In View, how can I make if statement over there?

 

[pdx_man]

This works fine:

use Northwind
GO

Create View NorthTemp AS
SELECT e.LastName, [Check] = CASE WHEN e.Region = 'WA' THEN 'T' ELSE 'Exe' END
FROM northwind.dbo.Employees e 
GO

select * from northwind.dbo.NorthTemp

GO
drop view NorthTemp

 

[tehNellie]

I've noticed a couple of instances where the View designer objects to things such as linked servers that will work just fine in Query Analyser. I can only suggest designing the View using the view designer if you want to and then using Query Analyser to actually create or amend the view.

 

[jknow]

I have used CASE statements in many views.
Will this not work?
SELECT Date, CASE WHEN [Elec] = 'A' THEN 'T' ELSE 'Exe' END as [Check]
FROM Employees

 

[pdx_man]

It will ... there is something else going on here, but Accessman2 never follows up with the results of what he gleans from here.

 

[jknow]

I'm sorry to hear that. I like to be able to see what works and what doesn't so that everyone can benefit.

 

[pdx_man]

Yeah, I do too. It is the reason Accessman2 has red jello (reputation). He doesn't play nice.