|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
select case
I need to do nested select case statement. I try to do, however it is not working. Please help
SELECT CASE freq_type WHEN 1 THEN 'Once' WHEN 4 THEN 'Daily' WHEN 8 THEN 'Weekly' ELSE 'N/A' END as [Frequency of the schedule execution], [days the schedule runs]= Case freq_type WHEN 4 then 'Daily' WHEN 8 then CASE freq_interval WHEN '1' THEN 'Sunday' WHEN '2' THEN 'Monday' WHEN '4' THEN 'Tuesday' WHEN '8' THEN 'Wednesday' WHEN '16' THEN 'Thursday' WHEN '32' THEN 'Friday' WHEN '64' THEN 'Saturday' ELSE 'N/A' END WHEN 32 THEN CASE freq_interval WHEN '1' THEN 'Sunday' WHEN '2' THEN 'Monday' WHEN '3' THEN 'Tuesday' WHEN '4' THEN 'Wednesday' WHEN '5' THEN 'Thursday' WHEN '6' THEN 'Friday' WHEN '7' THEN 'Saturday' WHEN '8' THEN 'Day' WHEN '9' THEN 'Weekday' WHEN '10' THEN 'Weekned Day' END END FROM msdb..sysjobschedules a JOIN msdb..sysjobs b ON a.job_id=b.job_id |
|
#2
|
||||
|
||||
|
please define "not working"
returns the wrong rows? returns 0 rows? issues a syntax error? crashes the server? |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > select case |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|