quan23 (7/4/2011)

---

Using the DelimitedSplit8K function that The Ninja provided the link to, you would need to change the where clause in the sp from

DIRECTION IN (@direction)

to

DIRECTION IN (select item...

Thanks for coming in. I feel squeezy giving advice about something I never had to deal with! 😉

Ninja's_RGR'us (7/4/2011)

---

The usual suspect is that you have used this type of syntaxe which works in the ssrs query generator, but then fails in the sp.

where something IN (@MultiSelectParam).

If you...

See my sample code and adapt it.

CASE(SUM...) will work perfectly for you. If you want a fully tested solution post the ddl, sample data (insert statements) and required output...

threshold for parallelism expert needed here.

http://www.sqlservercentral.com/Forums/Topic1135362-391-1.aspx

The problem is not parallelism itself. It's the minimum cost at which the server starts using it. P. also comes with the costs of remerging the results...

What we're [all] still waiting for is ddl / sample data to give you the correct answer.

SELECT SUM(CASE WHEN DateCol = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) THEN Value ELSE 0...

Please post the sp code here.

muthukkumaran Kaliyamoorthy (7/4/2011)

---

Incorrect syntax near '('. on Line 38

LINE38 > FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL , NULL) IPS

I noticed the compatibility mode of our db = 80 (SQL 2000)

Already...

tt-615680 (7/4/2011)

---

steveb. (7/4/2011)

---

but without the t-log backups you will lose a days worth of data if there is a disaster. since you do not have the ability to...

steveb. (7/4/2011)

---

but without the t-log backups you will lose a days worth of data if there is a disaster. since you do not have the ability to do...

Much longer and might break something else...

#1 This script is more complete and customizable

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

#2 You can run the query without any modification. You just have to run it from master (or any other db that...

That's the best one, so far!

http://www.sqlservercentral.com/articles/Tally+Table/72993/