SQL: Using CROSS APPLY to replace multi-column predicate look-ups in T-SQL

added by DotNetKicks
7/22/2019 5:10:05 PM

1 Kicks, 180 Views

A few months ago, I was asked a question by a friend of mine who is also a Data Platform MVP. He was trying to express a query like this: I'm trying to select stock items where the combinations of Size and LeadTimeDays are in the list.