Declare @UserId as integer
Declare @bSpotFx as varchar(35)
declare @sProductName as varchar(35)
declare @ssql as varchar(255)	
declare @i as integer
select @i=1
declare cursorproduct Cursor

For
select productname from product_tbl
open cursorproduct 
Fetch next from cursorproduct
into @sproductname
while (@@fetch_status <> -1)
begin
	Declare cursorprofile Cursor For	
		select  userid,('+ @sproductName +') from userprofile_tbl where
		USERID>0
	OPEN cursorProfile
	FETCH  NEXT from cursorprofile
	Into @userid,@bSpotFx
	WHILE (@@fetch_status <> -1)
	BEGIN
	print @i
	print @userid
	print @bspotfx
	/*Insert into UserProduct_tbl values(@i,@userid,@bspotfx)*/
	FETCH  NEXT from cursorprofile
	Into @userid,@bSpotFx
	END
	close cursorprofile
	deallocate cursorprofile
fetch next  from cursorproduct
into @sproductname
select @i=@i+1
end

close cursorproduct