View Single Post
  #6 (permalink)  
Old 05-05-2008, 09:01 PM
bluesky bluesky is offline
D-Web Analyst
 
Join Date: Jun 2007
Posts: 201
bluesky is on a distinguished road
Default Re: Sql loop Statement

Hi shaalini.
Can u try with the following query

DECLARE @MaxRecId as INT
SELECT @MaxRecId = MAX(RecId )
FROM Rec


SET IDENTITY_INSERT Rec ON
INSERT INTO Rec (RecId,[Name],Description)
SELECT RecId = RecId + @MaxRecId ,
[Name] = [Name],
Description= Description,
FROM Rec
SET IDENTITY_INSERT Rec OFF

INSERT INTO RecItem(RecId,ItemId)
SELECT RecId = RecId + @MaxRecId ,
ItemId= ItemId
FROM RecItem
Reply With Quote