[font="Verdana"]Write a function and pass the whole string to it as a parameter. And inside the function write a loop and check the occurance of comma when you found comma...

[font="Verdana"]First convert the CSV, I mean Row to Column and insert the values into temp table then write a simple query on that temp table like:

Delete From tempTable Where value...

[font="Verdana"]check the connection string, which database you have mentioned in it. Correct it with the desired DB Name.

Mahesh[/font]

[font="Verdana"]

Sorry...

[font="Verdana"]Ohh... I got it. Hopes the below url will help you out.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

you need to just add your condition there.

Mahesh

[/font]

[font="Verdana"]

Grant Fritchey (5/5/2008)

---

How many have you got?

Seriously though, I've seen performance begin to degrade after 50 or so joins, mostly due to the time it takes to compile the query,...

[font="Verdana"]You havn't posted the exact example. Coz you stated, you need summation of the number table, but on the basis of your example on what basis you need summation?

If you...

[font="Verdana"]

1] Inner Join: Returns the matching records from both the tables

2] Outer Join

2.1] Left Outer Join: Returns the matching records from both the tables + rest...

[font="Verdana"]Views stores query with execution plan. So I think using views might be better over using tables directly.

Mahesh[/font]

[font="Verdana"]CTE is based on anchor member and recursive member, so I think(not sure, even never tried as well), it can not be possible to use the resultset of executed SProc...

[font="Verdana"]Any idea friends?

Thanks again,

Mahesh[/font]

[font="Verdana"]

Are you handling errors at front end with Try Catch block? Not sure,...

[font="Verdana"]While filtering, when you put '-' in between the value it compares the value with the column value and it might raise error due to mismatch datatypes of the column...

[font="Verdana"]Have you tried to execute it with sp_executesql?

From BOL:

Using sp_executesql is recommended over using the EXECUTE statement to execute a string. Not only does the support for parameter substitution make...

[font="Verdana"]

I would suggest, optimize the view...