Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. --SELECT Item FROM dbo.SplitString(@mystring, @delim)
  2. CREATE FUNCTION SplitString
  3. (
  4. @Input NVARCHAR(MAX),
  5. @Character CHAR(1)
  6. )
  7. RETURNS @Output TABLE (
  8. Item NVARCHAR(1000)
  9. )
  10. AS
  11. BEGIN
  12. DECLARE @StartIndex INT, @EndIndex INT
  13.  
  14. SET @StartIndex = 1
  15. IF SUBSTRING(@Input, LEN(@Input) - 1, LEN(@Input)) <> @Character
  16. BEGIN
  17. SET @Input = @Input + @Character
  18. END
  19.  
  20. WHILE CHARINDEX(@Character, @Input) > 0
  21. BEGIN
  22. SET @EndIndex = CHARINDEX(@Character, @Input)
  23.  
  24. INSERT INTO @Output(Item)
  25. SELECT SUBSTRING(@Input, @StartIndex, @EndIndex - 1)
  26.  
  27. SET @Input = SUBSTRING(@Input, @EndIndex + 1, LEN(@Input))
  28. END
  29.  
  30. RETURN
  31. END
  32. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement