SQL SPLIT

From Logic Wiki

Jump to: navigation, search

When you need to pass a string variable to a stored procedure, you can split it in a query like below

(@Areas is null or r.AreaCode IN (SELECT value FROM STRING_SPLIT(@Areas, ',')) )


	SELECT * FROM [dbo].[tblAction]
		WHERE Assignee IN (SELECT value FROM STRING_SPLIT(@Assignee, ',')) 
		ORDER BY CreateDate Desc

Retrieved from "https://www.logicwiki.co.uk/index.php?title=SQL_SPLIT&oldid=1327"

SQL