As you are using 2008 , why not use a TVP ? (Table Value Parameter)

For those interested , attached is the script i used at sqlbits.

All pretty self explanatory really, i choose the tally split function to demonstrate

A) You cant trust the...

Jack Corbett (10/4/2010)

---

Roy Ernest (10/4/2010)

---

I will be sending an email to my members regarding the next topic they would like to see in T-SQL. That I think is the best...

Thanks all , its a whole new scary world into which ive taken the first few pigeon steps.

The cost of sqlbits (3 days worth including 1 day precon)...

All the session were filmed , so will be on the sqlbits site "at some point".

Started off , other than pre-amble, with a run through of my "Fifo" query from...

Cool,

WITH (NOEXPAND) is different. Post the plan with that on , IMO its not a hint more of an instruction.

Please see this article

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ordinarily, you shouldnt really need to provide a merge query hint.

Remove it ,...

Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked "who uses tally tables"....

Gianluca Sartori (9/30/2010)

---

Totally different topic: how big was the biggest SQL statement you had to deal with?

This is a statement generated by our BI front-end.

Surprisingly enough, after 4 minutes of...

unfortunately it is not supported .

You will have to use replace to convert to the 'us-english' standard on using a fullstop.

Vote up this item

http://connect.microsoft.com/SQLServer/feedback/details/126363/escape-character-for-decimal-point

Please see this page

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

So , something like this ?

select 4, sum(case when seqno =3 then 0-amt1 else amt1 end) as amt1,

sum(case when seqno...

Because you have multiple rows in your source WHICH 1,2 and 3 are you referring to ?

Before you throw hardware at that issue , make sure the queries are tuned correctly and you are using indexes etc...

Then you really are stuffed. 🙂

You will have to generate a dynamic sql statement to do this , if you...