quote:

---

Originally posted by chakadoll

I have a data.frame which has two columns as the following:
one two
1 2
3 4
5 6

I used the "paste" function to create the third column: three <- paste(one,'-',two,sep="")
so the data.frame is like this now:
one two three
1 2 1-2
3 4 3-4
5 6 5-6

That's all I know, Be back for more!


Thanks
Chaka
http://www.sqlhosting.net/

---

where 
   ','+ @categorylist +',' like '%',+cast(jobcategory as varchar(32)) + ',%'

quote:

---

Originally posted by sunitabeck

I can think of couple of different ways to try to do this. First is to use the like operator:

where 
   ','+ @categorylist +',' like '%',+cast(jobcategory as varchar(32)) + ',%'

This may not be any faster than the method you tried. Another alternative is to split the comma-separated list into a table and then join with that table. To split the comma-separated list, you can install the function listed in Fig. 21 of this page: http://www.sqlservercentral.com/articles/Tally+Table/72993/ and use it.

BUT, if you really really want great performance, you have to make sure that you have the appropriate indexes on the table. Post your table DDL, including indexes, and there are people on this forum who can take one look at it and say something like "add two indexes, one on the categoryid column and another on the jobtype column(*)", and like magic, the query will run a lot faster.

Brett's blog here has info on how to get the table DDL: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

(*) The indexes I have listed above are purely fictional. Any resemblance to real indexes, clustered, or non-clustered, is purely coincidental.

---

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[udf_Table]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[udf_Table]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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)+1, LEN(@ParmList)-CHARINDEX(@Delim,@ParmList))
	  END 
	INSERT INTO @table(Parameter) SELECT @ParmList
	RETURN
END

GO