The SQL Server field is a comma-separated ID, and the associated schedule query

Sometimes a field in a table is a comma-separated string, and the split number is the primary key ID of the schedule.

The associated schedule query can do this:

Declare @str  as nvarchar( +)Declare @areanos  as  nvarchar( $) --This is the assignment of the Areanos field to the @areanos variableSet @areanos=' the' --Assigning a stitched SQL script to a variableSet @str='SELECT * from area where Areano in ('+@areanos+') Order by Areano'--call system stored procedure, execute SQLexecsp_executesql@str 

The SQL Server field is a comma-separated ID, and the associated schedule query