you better start making backups now..but hey it's only a temp table
Can you post something would sound like a business requirement?
This is just flat out wrong
WHERE ISNULL(supervisorId,0) <> @supervisorId
And yes, you need a user defined function
What does the sting look like?
CREATE FUNCTION [dbo].[udf_Table](@ParmList varchar(8000), @Delim varchar(20))
RETURNS @table TABLE
(Parameter varchar(255))
AS
/*
SELECT * FROM dbo.udf_Table( 'a|~|b|~|c', '|~|')
*/
BEGIN
DECLARE @x int, @Parameter varchar(255)
WHILE CHARINDEX(@Delim, @ParmList)-1 > 0
BEGIN
INSERT INTO @table(Parameter)
SELECT SUBSTRING(@ParmList,1,CHARINDEX(@Delim, @ParmList)-1)
SELECT @ParmList = SUBSTRING(@ParmList,CHARINDEX(@Delim, @ParmList)+LEN(@Delim), LEN(@ParmList)-CHARINDEX(@Delim,@ParmList))
END
INSERT INTO @table(Parameter) SELECT @ParmList
RETURN
END
GO
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Want to help yourself?
http://msdn.microsoft.com/en-us/library/ms130214.aspx
http://weblogs.sqlteam.com/brettk/
http://brettkaiser.blogspot.com/
Issue with IN
Posted - 11/17/2011 : 13:29:32
