Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE CHKIndex
- @count DECIMAL(10,2) ,
- @ID INT = NULL,
- @DATE VARCHAR (MAX)
- AS
- SELECT DISTINCT
- COL1,
- COL2
- FROM
- (
- SELECT COL1,COL2,rn
- FROM TAB1 T1 INNER JOIN TAB2 T2
- ON T1.SNO = T2.PNO
- )t
- where t.rn = 1
- AND DATE = @DATE
- AND t.ID = @ID
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement