Sir,
there are collections of Ward_id as @wid varchar(max)='2,3,4,5,6,7,8'
I want to save these values in a table having columns as (UserID,district_id,localbody_id,ward_id).
district_id, localbody_id & user_id would be same with a pair of ward_ids therefore that values should get inserted in table together as a separate row for each.
If there is a sigle wardid then also it should get save...
What should I do to save these data at once.
I am using SQL SERVER 2012