advanced code snippet search

Posted By

sekihin on 08/04/10


Tagged

mssql


Versions (?)

GET MIN CD

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT TEMPCD FROM (SELECT (CD+1) AS CD FROM MASTERTABLE) WHERE TEMPCD NOT IN (SELECT CD FROM MASTERTABLE) ORDER BY TEMPCD

Report this snippet  

You need to login to post a comment.