Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT ID,NAME,Age, ISNULL(timeone,'01:00:03') AS timeone,
- ISNULL(timetwo,'02:00:03') AS timetwo,
- ISNULL(timethree,'01:00:03') AS timethree,
- ISNULL(timefour,'02:00:03') AS timefour,
- ISNULL(timefive,'01:00:03') AS timefive,
- ISNULL(timesix,'02:00:03') AS timesix
- SELECT ID,NAME,AGE, (SELECT TOP(1) TIMEONE from [TABLE] WHERE ID = [ID] AND TIMEONE
- is not null)
- FROM [TABLE]
Add Comment
Please, Sign In to add comment