How to get id one by one

Question

Hello i dont understand how i do that i have one table in this table has id industry id uniq and industry has like ITDESIGNSCO now i want to like that im get one by one id and sepret the industry without comma and insert into new table one by one like 1-----IT 1----DESIGN 1---SCO so how to do this in sql plz help me

Prabhu Raja · Answer

Hi Try this . (U tested) DECLARE C CURSOR FOR Select ID industryid industry From Tablename OPEN C DECLARE @ID varchar(100) @IndustryID varchar(100) @Industry varchar(100) FETCH NEXT FROM C INTO @ ID  @ IndustryID  @Industry WHILE @@FETCH_STATUS = 0 BEGIN PRINT N @ID; PRINT N @ IndustryID ; PRINT N @ Industry ; FETCH NEXT FROM C INTO @ ID  @ IndustryID  @Industry END CLOSE C DEALLOCATE C

Dharmesh sharma · Answer

give me some idea or code for this plz

DRISHTY · Answer

Create one stored procdure. In that stored procedure writedown logic of creating cursor and perform operation row by row.

DRISHTY · Answer

You can use SQL CURSOR for row by row operation.