cursor structure
DECLARE @fileUrl VARCHAR(500)
DECLARE @productId INT
DECLARE crsr CURSOR FOR
SELECT ID,FileUrl FROM dbo.Product WHERE ISNULL(FileUrl,'') <>''
OPEN crsr
FETCH NEXT FROM crsr INTO @productId,@fileUrl
WHILE @@FETCH_STATUS =0
BEGIN
UPDATE dbo.ProductDescription SET FileUrl=@fileUrl WHERE ProductID=@productId AND LanguageID=1
FETCH NEXT FROM crsr INTO @productId,@fileUrl
END
CLOSE crsr
DEALLOCATE crsr