8
Answers

Select from table not working

Marius Vasile

Marius Vasile
Oct 22
455
1

I am trying to get data from table with query below, basically trying to get int val from Value field for each month as V1, V2, etc

SELECT 
	(CASE When Month = 'January' Then Value Else 0 End) AS V1, 
	(CASE When Month = 'February' Then Value Else 0 End) AS V2, 
	(CASE When Month = 'March' Then Value Else 0 End) AS V3, 
	(CASE When Month = 'April' Then Value Else 0 End) AS V4, 
	(CASE When Month = 'May' Then Value Else 0 End) AS V5, 
	(CASE When Month = 'June' Then Value Else 0 End) AS V6, 
	(CASE When Month = 'July' Then Value Else 0 End) AS V7, 
	(CASE When Month = 'August' Then Value Else 0 End) AS V8, 
	(CASE When Month = 'September' Then Value Else 0 End) AS V9, 
	(CASE When Month = 'October' Then Value Else 0 End) AS V10, 
	(CASE When Month = 'November' Then Value Else 0 End) AS V11, 
	(CASE When Month = 'December' Then Value Else 0 End) AS V12

	FROM tblOmOra WHERE Year=@CurrentYear;

What is wrong with this query?

Answers (8)
Next Recommended Forum