27 lines
736 B
Transact-SQL
27 lines
736 B
Transact-SQL
IF OBJECT_ID('dbo.fnGetDokumentumIntezmenyCime') IS NOT NULL BEGIN
|
|
DROP FUNCTION dbo.fnGetDokumentumIntezmenyCime
|
|
END
|
|
GO
|
|
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE FUNCTION dbo.fnGetDokumentumIntezmenyCime (@tanevId INT)
|
|
RETURNS NVARCHAR(MAX)
|
|
BEGIN
|
|
DECLARE @value NVARCHAR(MAX)
|
|
|
|
SELECT
|
|
@value = C_IRANYITOSZAM + ', ' + C_VAROS + ', ' + C_KOZTERULETNEV + ' ' + kj.C_NAME + ' ' + ia.C_HAZSZAM + ISNULL(', ' + C_EMELET + '. emelet', '') + ISNULL(', ' + C_AJTO + '. ajtó', '')
|
|
FROM T_INTEZMENYADATOK_OSSZES ia
|
|
INNER JOIN T_DICTIONARYITEMBASE_OSSZES kj ON kj.id = ia.C_KOZTERULETJELLEG
|
|
where
|
|
ia.C_TANEVID = @tanevId
|
|
AND kj.c_tanevid = @tanevId
|
|
AND ia.TOROLT = 'F'
|
|
AND kj.TOROLT = 'F'
|
|
|
|
RETURN @value
|
|
END; |