Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT
  2. CASE WHEN start = "0000-00-00" THEN NULL else start END as start,
  3. CASE WHEN finish = "0000-00-00" THEN NULL else finish END as finish
  4. FROM students
  5.  
  6. SELECT *
  7. FROM openquery(OLDSYSTEM, '
  8. SELECT
  9. CASE WHEN start = "0000-00-00" THEN NULL else start END as start,
  10. CASE WHEN finish = "0000-00-00" THEN NULL else finish END as finish
  11. FROM students')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement