Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create function F5(
- @status varchar(200),
- @sektor int
- )
- returns varchar(200)
- as
- begin
- declare @str varchar(1000)
- SELECT @str= coalesce(@str + ', ', '') + a.nextstatus
- FROM (SELECT DISTINCT nextstatus from krstatuspart_nextstatus where status=@status and sektor = @sektor) a
- return @str
- end
- select dbo.F5('PR',9)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement