Guest User

Untitled

a guest
Jan 21st, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. tblCriteria (CriteriaID, CriteriaText)
  2. tblFilterRun (FilterRunID, FilterRunDate)
  3. tblFilterResults (FilterResultsID, FilterRunID, RecordID, Ref, CustomerID, SupplierID
  4. tblRecords (RecordID, CustomerID, SupplierID...)
  5.  
  6. SELECT *
  7. FROM tblCriteria
  8. CROSS APPLY dbo.udf_yourFunction(parameter1, parameter2, etc)
Add Comment
Please, Sign In to add comment