HOW TO AVOID USING CURSORS IN SQL PROGRAMMING

SYNTAX:-

declare @count int,

@i int,

@productid int,

@productname varchar(500)

declare @tab1 table (sno int identity(1,1),productid int)

declare @tab2 table (produtname varchar(500),denom varchar(100))

insert into @tab1(productid) select distinct productid from products

set @count=select count(sno) from @tab1 while (@i<=@count)

begin

select @productname=productname,@denom=deno from productdetails where productid=@productid

insert into @tab2 (productname,denom) values (@productname,@denom)

select @i=@i+1

end

select * from @tab2

Note: for any clarifications/assistance feel free to contact me at chinna7485@gmail.com