28 lines
822 B
Transact-SQL
28 lines
822 B
Transact-SQL
IF OBJECT_ID('dbo.sp_GetHelyettesitoTanarTanorahoz') IS NOT NULL BEGIN
|
|
DROP PROCEDURE dbo.sp_GetHelyettesitoTanarTanorahoz
|
|
END
|
|
GO
|
|
-- =============================================
|
|
-- Author: <Zsiga Attila>
|
|
-- Create date: <2016.03.09.>
|
|
-- Description: <Tanorahoz tartozo helyettesito tanar>
|
|
-- =============================================
|
|
Create PROCEDURE [dbo].[sp_GetHelyettesitoTanarTanorahoz]
|
|
-- Add the parameters for the stored procedure here
|
|
@pOrarendiOraID int,
|
|
@pDatum DateTime
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT
|
|
tto.C_HELYETTESITOTANARID HelyettesitoID
|
|
FROM T_ORARENDIORA oo
|
|
JOIN T_TANITASIORA tto ON tto.C_ORARENDIORAGROUPID = oo.C_ORARENDIORAGROUPID AND tto.C_DATUM BETWEEN oo.C_ORAERVENYESSEGKEZDETE AND oo.C_ORAERVENYESSEGVEGE
|
|
WHERE
|
|
oo.ID = @pOrarendiOraID
|
|
AND tto.C_DATUM = @pDatum
|
|
|
|
END
|
|
GO
|