44 lines
1.4 KiB
Transact-SQL
44 lines
1.4 KiB
Transact-SQL
-- =============================================
|
|
-- Description: <Előszedjük az értékelés mondatbank exporthoz az adatokat>
|
|
-- =============================================
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
DROP PROCEDURE IF EXISTS [dbo].[uspGetTanuloErtekelesMondatbankExportData]
|
|
GO
|
|
|
|
CREATE PROCEDURE [dbo].[uspGetTanuloErtekelesMondatbankExportData]
|
|
@pIntezmenyId INT
|
|
,@pTanevId INT
|
|
,@pTanuloErtekelesTipusId INT = NULL
|
|
,@pEvfolyamTipusId INT = NULL
|
|
,@pTantargyId INT = NULL
|
|
,@pTipusId INT
|
|
AS
|
|
BEGIN
|
|
|
|
-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT
|
|
TanuloErtekelesMondatbank.C_ROVIDNEV RovidNev
|
|
,TanuloErtekelesMondatbank.C_SZOVEG Szoveg
|
|
FROM
|
|
T_ERTEKELESMONDATBANK_OSSZES TanuloErtekelesMondatbank
|
|
WHERE
|
|
(@pTanuloErtekelesTipusId IS NULL OR TanuloErtekelesMondatbank.C_ERTEKELESTIPUSA = @pTanuloErtekelesTipusId)
|
|
AND (@pEvfolyamTipusId IS NULL OR TanuloErtekelesMondatbank.C_EVFOLYAMTIPUSA = @pEvfolyamTipusId)
|
|
AND (@pTantargyId IS NULL OR TanuloErtekelesMondatbank.C_TANTARGYID = @pTantargyId)
|
|
AND ((TanuloErtekelesMondatbank.C_TIPUSID = @pTipusId) OR (@pTipusId = 7357 AND TanuloErtekelesMondatbank.C_TANTARGYID IS NULL))
|
|
AND TanuloErtekelesMondatbank.C_INTEZMENYID = @pIntezmenyId
|
|
AND TanuloErtekelesMondatbank.C_TANEVID = @pTanevId
|
|
AND TanuloErtekelesMondatbank.TOROLT = 'F'
|
|
|
|
END
|
|
|
|
|
|
GO
|
|
|