Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DocIDs TABLE
- (
- ID BIGINT
- )
- INSERT INTO @DocIDs
- SELECT Item FROM dbo.fn_SplitToBigint(@OrderIDs, ';')
- SELECT *
- FROM IROrderDocumentCustomModel as cm
- INNER JOIN @DocIDs as d ON d.ID = cm.IROrderDocumentID
- WHERE cm.IsDeleted = 0
- SELECT *
- FROM IROrderDocumentCustomModel as cm
- WHERE cm.IsDeleted = 0
- AND cm.IROrderDocumentID IN (SELECT ID FROM @DocIDs)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement