Ciezko wam dogodzic ;)
IF OBJECT_ID('tempdb..#customers_temp') IS NOT NULL
DROP TABLE #customers_temp;
DECLARE @Customers TABLE
(
Id TINYINT ,
[First name] VARCHAR(255) ,
[Last name] VARCHAR(255)
);
INSERT INTO @Customers
VALUES ( 1, 'Akshay', 'Kumar' ) ,
( 2, 'Salman', 'Khan' ) ,
( 3, 'Kamal', 'Haasan' ) ,
( 4, 'Sahid', 'Kumar' );
DECLARE @Id TINYINT;
DECLARE @lastname VARCHAR(255);
DECLARE customers_cursor CURSOR FOR
SELECT Id ,
[Last name]
FROM @Customers;
OPEN customers_cursor;
FETCH NEXT FROM customers_cursor
INTO @Id ,
@lastname;
IF @lastname = 'Kumar'
SELECT *
INTO #customers_temp
FROM @Customers
WHERE Id = @Id;
FETCH NEXT FROM customers_cursor
INTO @Id ,
@lastname;
WHILE @@FETCH_STATUS = 0
BEGIN
IF @lastname = 'Kumar'
INSERT INTO #customers_temp
SELECT *
FROM @Customers
WHERE Id = @Id;
FETCH NEXT FROM customers_cursor
INTO @Id ,
@lastname;
END;
CLOSE customers_cursor;
DEALLOCATE customers_cursor;
SELECT *
FROM #customers_temp;
Jak mi w firmie junior podobne cudo wypocil to mu kazelem [CIACH!] :)