43 lines
1.1 KiB
Transact-SQL
43 lines
1.1 KiB
Transact-SQL
|
|
GO
|
|
/****** Object: StoredProcedure [sp_GetNemKotottMunkaIdoAdmin] Script Date: 2016.10.12. 9:50:22 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
IF OBJECT_ID('[dbo].[sp_GetNemKotottMunkaIdoAdmin]') IS NOT NULL
|
|
BEGIN
|
|
DROP PROCEDURE [dbo].[sp_GetNemKotottMunkaIdoAdmin]
|
|
END
|
|
GO
|
|
|
|
CREATE PROCEDURE [sp_GetNemKotottMunkaIdoAdmin]
|
|
@IntezmenyId int
|
|
,@TanevId int
|
|
,@IdoszakKezdete datetime
|
|
,@IdoszakVege datetime
|
|
,@TanarId int
|
|
,@UserId int
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT
|
|
nkm.ID as Id
|
|
,nkm.C_GROUPID as GroupID
|
|
,nkm.C_KEZDETE as Kezdete
|
|
,nkm.C_MEGJEGYZES as Megjegyzes
|
|
,nkm.C_NAPLOZOTTMEGJEGYZES as NaplozottMegjegyzes
|
|
,nkm.C_MEGTARTOTT as Megtartott
|
|
,nkm.C_TEVEKENYSEGTIPUSA as TorvenyKategoriaID
|
|
,nkm.C_VEGE as Vege
|
|
,nkm.C_TANARID as TanarID
|
|
,nkm.C_TULAJDONOSID as TulajdonosID
|
|
,nkm.TOROLT as Torolt
|
|
FROM T_NEMKOTOTTMUNKAIDO nkm
|
|
WHERE
|
|
nkm.TOROLT = 'F' AND nkm.C_ADMINALTALTOROLT = 'F' AND nkm.C_INTEZMENYID = @IntezmenyId AND nkm.C_TANEVID = @TanevId AND nkm.C_TANARID = @TanarId
|
|
AND @IdoszakKezdete <= C_KEZDETE AND @IdoszakVege > C_VEGE AND nkm.C_TULAJDONOSID = @UserId
|
|
|
|
END |