How Do You Pass In Multi-select parameters into a Stored Procedure?
I need the results to be in a @LOB_KEY
the code:
HAVING CLAIM_LAST_STATUS IN (@CLAIM_STATUS)
AND LOB_KEY IN (@LOB_KEY)
AND POLICY_YR IN (@POLICY_YR)
Open in new window
The @LOB_KEY needs to be passed in and partitioned into multiple values:
HAVING IN (value1, value2 etc..) CLAUSE
Any advice on a solution is appreciated.
Dan
Open in new window
How do you get this code to work? What is the best syntax?
Dan