|
|
example of a Cursor
Last post 09-16-2009, 1:21 PM by twaligora. 0 replies.
-
 09-16-2009, 1:21 PM |
-
twaligora
-
-
-
Joined on 01-11-2007
-
-
Posts 57
-
-
|
-- ---- CURSOR FOR INSERT
DECLARE @CUST_IDS INT
DECLARE CU_GET_CUSTOMER_IDS CURSOR FOR
SELECT ID FROM FT_CUSTOMER WHERE NAME = @CUST_NAM
OPEN CU_GET_CUSTOMER_IDS
FETCH NEXT FROM CU_GET_CUSTOMER_IDS INTO @CUST_IDS
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM CU_GET_CUSTOMER_IDS INTO @CUST_IDS
END
CLOSE CU_GET_CUSTOMER_IDS
DEALLOCATE CU_GET_CUSTOMER_IDS
|
|
|
|
|