Advertisement
Guest User

Untitled

a guest
Apr 13th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.39 KB | None | 0 0
  1. DECLARE @DocIDs TABLE
  2.      (
  3.         ID BIGINT
  4.      )
  5.      INSERT INTO @DocIDs
  6.      SELECT Item FROM dbo.fn_SplitToBigint(@OrderIDs, ';')
  7.  
  8.  
  9. SELECT *
  10.      FROM IROrderDocumentCustomModel as cm
  11.           INNER JOIN @DocIDs as d ON d.ID = cm.IROrderDocumentID
  12.      WHERE cm.IsDeleted = 0
  13.  
  14. SELECT *
  15.      FROM IROrderDocumentCustomModel as cm
  16.      WHERE cm.IsDeleted = 0
  17.           AND cm.IROrderDocumentID IN (SELECT ID FROM @DocIDs)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement