I suppose this is a stored procedure, isn't it?

Then you expect some kind of parameter. If it is a single char parameter, you will have to split it on commas...

This should do:

DECLARE @Procs TABLE (

Proc nvarchar(50)

)

DECLARE @Diags TABLE (

Diag nvarchar(50)

)

INSERT INTO @Procs

SELECT 'VALUE1'

UNION ALL

SELECT 'VALUE2'

UNION ALL

SELECT 'VALUE3'

UNION ALL

SELECT 'VALUE4'

INSERT INTO @Diags

SELECT * FROM @Procs

SELECT S.crn,

...

I find it hard to believe.

Have you tried this:

DECLARE @sql nvarchar(max)

SET @sql = N'

SELECT COUNT(IndustyID)

FROM dbo.Industry

'

IF @criteria1 = 1

SET @sql = @sql + N'

WHERE ...

Koen Verbeeck (5/26/2011)

You don't get free money??? :w00t: :hehe:

After all, be lucky you are not freelancing...

Looks like a good place for dynamic sql and sp_executesql.

Have you tried that?

In my case it will...

Stefan Krzywicki (5/26/2011)

Gianluca Sartori (5/26/2011)

Jeff Moden (5/25/2011)

You have the right...

Impressive. You would have...

I suspect that the best option is coding a CLR assembly to replace the characters that don't match the pattern with a space.

T-SQL is not the best tool for this...

SELECT Name, MAX([Used Food]) AS Max_Used_Food

FROM SomeTable

GROUP BY Name

Congrats, Remi!

And thank you very much.

You can use this script to capture tempdb usage per active session and find the offending query:

http://www.sqlservercentral.com/scripts/tempdb/72007/

Probably one of your queries is not properly tuned and spills internal objects to...

Dave Ballantyne (5/26/2011)

Echo those thoughts , i could only justify...

Jeff Moden (5/25/2011)

You have the right attitude, Gianluca. You'll...

Great! Thank you, Jason.