25 lines
563 B
Transact-SQL
25 lines
563 B
Transact-SQL
|
|
DROP PROCEDURE IF EXISTS kreta.uspSetSession;
|
|
GO
|
|
|
|
CREATE PROCEDURE kreta.uspSetSession
|
|
WITH EXECUTE AS OWNER
|
|
AS
|
|
SET NOCOUNT ON;
|
|
DECLARE @IntezmenyId INT;
|
|
DECLARE @TanevId INT;
|
|
|
|
SELECT @IntezmenyId = ID
|
|
FROM T_INTEZMENY
|
|
WHERE C_AZONOSITO = REPLACE(REPLACE(ORIGINAL_LOGIN(), 'KR_', ''), '_user', '')
|
|
AND TOROLT = 'F'; -- index seek
|
|
|
|
SELECT @TanevId = ID
|
|
FROM T_TANEV
|
|
WHERE C_INTEZMENYID = @IntezmenyId
|
|
AND C_AKTIV = 'T'
|
|
AND TOROLT = 'F'; -- index seek
|
|
|
|
EXEC sp_set_session_context N'INTEZMENYID', @IntezmenyId;
|
|
EXEC sp_set_session_context N'TANEVID', @TanevId;
|
|
GO
|