Advertisement
Guest User

Untitled

a guest
Oct 25th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. CREATE PROCEDURE CHKIndex
  2.  
  3. @count DECIMAL(10,2) ,
  4. @ID INT = NULL,
  5. @DATE VARCHAR (MAX)
  6.  
  7. AS
  8.  
  9. SELECT DISTINCT
  10. COL1,
  11. COL2
  12.  
  13. FROM
  14. (
  15.  
  16. SELECT COL1,COL2,rn
  17.  
  18.  
  19.  
  20. FROM TAB1 T1 INNER JOIN TAB2 T2
  21. ON T1.SNO = T2.PNO
  22.  
  23. )t
  24.  
  25.  
  26. where t.rn = 1
  27. AND DATE = @DATE
  28. AND t.ID = @ID
  29.  
  30. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement