Guest User

Untitled

a guest
Nov 19th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT DISTINCT ID,NAME,Age, ISNULL(timeone,'01:00:03') AS timeone,
  2. ISNULL(timetwo,'02:00:03') AS timetwo,
  3. ISNULL(timethree,'01:00:03') AS timethree,
  4. ISNULL(timefour,'02:00:03') AS timefour,
  5. ISNULL(timefive,'01:00:03') AS timefive,
  6. ISNULL(timesix,'02:00:03') AS timesix
  7.  
  8. SELECT ID,NAME,AGE, (SELECT TOP(1) TIMEONE from [TABLE] WHERE ID = [ID] AND TIMEONE
  9. is not null)
  10. FROM [TABLE]
Add Comment
Please, Sign In to add comment