# how to split the column values using stored procedure
- by user1444281
I have two tables
table 1 is
SELECT * FROM dbo.TBL_WD_WEB_DECK
WD_ID WD_TITLE
------------------
1 2
and data in 2nd table is
WS_ID WS_WEBPAGE_ID WS_SPONSORS_ID WS_STATUS
-----------------------------------------------------
1 1 1,2,3,4 Y
I wrote the following stored procedure to…