Advertisement
Guest User

Untitled

a guest
Feb 17th, 2020
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. create function F5(
  2. @status varchar(200),
  3. @sektor int
  4. )
  5. returns varchar(200)
  6. as
  7. begin
  8. declare @str varchar(1000)
  9.  
  10. SELECT @str= coalesce(@str + ', ', '') + a.nextstatus
  11. FROM (SELECT DISTINCT nextstatus from krstatuspart_nextstatus where status=@status and sektor = @sektor) a
  12.  
  13. return @str
  14. end
  15.  
  16. select dbo.F5('PR',9)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement