quote:

---

Originally posted by birdie3321

Hi all.

I have the following code:

<begin code>
DECLARE prod_cursor CURSOR
FOR
SELECT productid <--Problem child
FROM @products
OPEN prod_cursor
DECLARE @prodid_

FETCH NEXT FROM prod_cursor INTO @prodid_
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF(@@FETCH_STATUS <> -2)
BEGIN
(line by line processing)
END
FETCH NEXT FROM prod_cursor INTO @prodid_
END
CLOSE prod_cursor
DEALLOCATE prod_cursor

SELECT * from @prodid_
<end code>

Problem is that I am getting the cursor select's result first then the last select's result set. I only want the last result set. Is there a way i can supress the cursor result set?

many thanks



birdie3321

---

FETCH LAST FROM CURSOR_NAME

DECLARE prod_cursor SCROLL CURSOR
FOR....

quote:

---

Originally posted by birdie3321

sackets, i get a ton of single results sets when i do that and i have to cancel the query.

birdie3321

---

-- Update matching records
UPDATE		dst
SET		provid = src.provid,
		variantid = src.productid
FROM		@ProductFilter AS dst
INNER JOIN	@ProvsFilter AS src ON src.productid = dst.productid

-- Insert new records
INSERT		@ProductFilter
		(
			productid,
			provid,
			displayorder,
			VariantID,
			VariantDisplayOrder,
			ProductName,
			VariantName
		) 
SELECT		src.productid,
		src.provid,
		0,
		0,
		0,
		'',
		''
FROM		@ProvsFilter AS src
LEFT JOIN	@ProductFilter AS dst ON dst.productid = src.productid
WHERE		dst.productid IS NULL

DECLARE prov_cursor SCROLL CURSOR
FOR
	SELECT productid,provid,0,0,0,'',''
	FROM @provsfilter 

OPEN prov_cursor

DECLARE @prodid_ int, @provid_ int, @temp int, @variantid int, @temp3 int, @temp4 varchar(200),@temp5 varchar(200), @recCount int

FETCH LAST FROM prov_cursor INTO @prodid_, @provid_,@temp,@variantid,@temp3,@temp4,@temp5

WHILE (@@FETCH_STATUS <> -1)
	BEGIN
	IF(@@FETCH_STATUS <> -2)
	BEGIN
		SET @variantid = @prodid_
		SELECT * FROM @productfilter WHERE productid = @prodid_
		SET @recCount = @@rowcount
			IF(@recCount = 0) 
				BEGIN
				INSERT @productfilter (productid, provid, displayorder, VariantID, VariantDisplayOrder, ProductName, VariantName) 
				SELECT @prodid_,@provid_,@temp,@variantid,@temp3,@temp4,@temp5
				END
			ELSE
				BEGIN
				UPDATE @productfilter SET provid = @provid_, variantid = @variantid WHERE productid = @prodid_
				--print 'update made to productid: ' + cast(@prodid_ as varchar(10)) + ' with provid: ' + cast(@provid_ as varchar(10))
				END
			FETCH NEXT FROM prov_cursor INTO @prodid_, @provid_,@temp,@variantid,@temp3,@temp4,@temp5		

END 

END
--FETCH LAST FROM prov_cursor INTO @prodid_, @provid_,@temp,@variantid,@temp3,@temp4,@temp5 
CLOSE prov_cursor
DEALLOCATE prov_cursor
END