Question abaut sql query

Hi ,

Try like below sample code :

CREATE  TABLE tmp(Id INT IDENTITY(1,1),salsalkamut VARCHAR(20) , salsalkamuts  INT)
INSERT tmp SELECT 'Smartphon AB',2
INSERT tmp SELECT 'BB',3
INSERT tmp SELECT 'A',1
SELECT * FROM tmp
CREATE  TABLE finaltmp(salsalkamut VARCHAR(20) , salsalkamuts  INT)
DECLARE @i INT = 1 ,@Gocnt INT ,@j INT = 1
WHILE @i <= (SELECT MAX(Id) FROM tmp)
BEGIN
SELECT @Gocnt = salsalkamuts FROM tmp WHERE id = @i
SET @j = 1
WHILE @j <= @Gocnt
BEGIN
INSERT finaltmp SELECT salsalkamut,salsalkamuts FROM tmp WHERE Id = @i
SET @j = @j + 1
END
SET @i = @i + 1
END
SELECT * FROM finaltmp
--if you want to insert manually using Go 
CREATE  TABLE testinsert(Id INT IDENTITY(1,1),salsalkamut VARCHAR(20) , salsalkamuts  INT)
GO
INSERT testinsert SELECT 'Smartphon AB',2
GO 2
SELECT * FROM testinsert
--DROP TABLE finaltmp
--DROP TABLE tmp
--DROP TABLE testinsert

---

sathya --------- Mark as answered if my post solved your problem and Vote as helpful if my post was useful.