How to determine user ID from table where in same fields are stored two values, which can be stored like in explanation below?
DECLARE @prp_UserIds NVARCHAR(250);
SET @prp_UserIds = '30671,30955'
Parameters can be vise versa:
SET @prp_UserIds = '30955,30671'
You can use a table variable as below:
DECLARE @tab as table(UserID INT)
insert into @tab values(30671)
insert into @tab values(30955)
select UserID from @tab
So, you want some sort of string split function to break the string field down into a table of separate values?
...and then have a word with whoever designed this data model.
17 People are following this question.
