root/branches/TruckExpo/SQL/Functions/podajEmisje.txt @ 682

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER function [dbo].[podajEmisje]
(
@reklamaId int
)
returns nvarchar(1024)
as
begin
declare @emisje nvarchar(1024)

select 
        @emisje = coalesce(@emisje + ', ','') + cast([Nr wydania] as nvarchar(4))
        from dbo.[UKA¯E SIÊ W NR] 
        where reklamaId = @reklamaId
        order by [Nr wydania]

return @emisje
end
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO