Как лучше сделать select ?
SELECT [HEARING_MUF_ID],
MUF_FNAME+' '+MUF_LNAME,
FROM [dbo].[HEARINGS]
left join MUF on HEARING_MUF_ID=MUF_ID
WHERE
[HEARING_KM_ID] = @HEARING_KM_ID
and [HEARING_DATE] <= @newdate
или с UDF
SELECT
[HEARING_MUF_ID],
dbo.uf_MUF_GetName([HEARING_MUF_ID]) as MUF_NAME,
FROM [dbo].[HEARINGS]
WHERE
[HEARING_KM_ID] = @HEARING_KM_ID
and [HEARING_DATE] <= @newdate
ALTER Function uf_MUF_GetName(@MUF_ID as int )
Returns varchar(50)
as
begin
declare @MUFNEName varchar(50)
select @MUFNEName=MUF_FNAME + ' ' + MUF_LNAME
from dbo.muf
where MUF_ID=@MUF_ID
return @MUFNEName
Есть очень много справочников,стоит ли использовать UDF ?
|