kapil_kk (2/20/2013)
try this.. hope it will workSELECT
iSchoolYearCode,
CASE WHEN vcCalendarCategoryCode = 'Quarter Start Day' THEN dtCalendarDay ELSE 0 END AS QuarterStartDay,
CASE WHEN vcCalendarCategoryCode = 'Quarter Grade Closing' THEN dtCalendarDay ELSE 0 END AS QuarterGradeClosing
FROM #Temp1
Kapil I already try this
Here what i got
iSchoolYearCodeQuarterStartDayQuarterGradeClosing
20122012-08-30 00:00:00.0001900-01-01 00:00:00.000
20121900-01-01 00:00:00.0002012-11-07 00:00:00.000
20122012-11-08 00:00:00.0001900-01-01 00:00:00.000
20121900-01-01 00:00:00.0002013-01-25 00:00:00.000
20122013-01-30 00:00:00.0001900-01-01 00:00:00.000
20121900-01-01 00:00:00.0002013-04-08 00:00:00.000
20122013-04-09 00:00:00.0001900-01-01 00:00:00.000
20121900-01-01 00:00:00.0002013-06-13 00:00:00.000
but desired output Like as below
iSchoolYearCodeQuarter Start DayQuarter Grade Closing
20122012-08-30 00:00:00.0002012-11-07 00:00:00.000
20122012-11-08 00:00:00.0002013-01-25 00:00:00.000
20122013-01-30 00:00:00.0002013-04-08 00:00:00.000
20122013-04-09 00:00:00.0002013-06-13 00:00:00.000