No i nie wiem jak zrobić udate dla wszystkich rekordów z NrWirtualny. Gdzie tu mój błąd?
;with cte
as
(
SELECT
Cast(CAST(ROW_NUMBER() OVER(PARTITION BY year(DataZalozenia)
ORDER BY year(DataZalozenia) DESC)AS int) as nvarchar(10))
+'/'+ (SELECT Cast(YEAR(DataZalozenia)as nvarchar(4)))as NrWirtualny
FROM tbllokata
)
SELECT NrWirtualny from cte
DECLARE Moj_Cursor CURSOR FOR
SELECT NrWirtualny from cte;
OPEN Moj_Cursor;
FETCH NEXT FROM Moj_Cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Moj_Cursor;
--update TblLokata1 set nr(Nrwirtualny) from cte
END;
CLOSE Moj_Cursor;
DEALLOCATE Moj_Cursor
---Msg 208, Level 16, State 1, Line 16
---Invalid object name 'cte'.