Jack Corbett (9/25/2008)

---

Based on some of Jeff's other posts, he is pretty busy with work right now,...

Heh......

DECIMAL WHAT??? What is the actual datatype of the column...

Heh... "Loop" and "Lose" are both 4 letter words beginning with "L". 😛 Please see the following article for how to perform concatenation and some of the pitfalls to...

By the way... the methods shown in the articles are a bit faster than the XML methods and can also be used in SQL Server 2000. 😉

It's super simple to pass a single dimensional array to SQL Server as a comma delimited string and then to split it into a temp table or table variable using...

Those sprocs are the ones that SQL Server runs behind the scenes for nearly every stored proc. The real problem is not those, but the query the query that...

Do you have any SQL Server Agent jobs that are failing? I've found that, depending on what they do, they can leave open connections that hold on to resources....

BWAAHAA! No need to do the Polka with Convert, folks! 😛 Read the original post!

Notes4we, I recommend...

Just remember that TRUNCATE doesn't work in the presence of foreign keys. I believe they can be disabled rather than dropped, though.

prasanna_pathangi (9/25/2008)

---

Is there a way to tell MS SQL that it should give higher priority to a query?. that is, i want my query to execute even when another process...

It doesn't matter if you have a max of 8000 characters for a variable, or not. You cannot print more than 8000 characters in SQL Server in a single...

Actually, there IS a limit on the size of stored procedures and batches... it's (65,536 * Network packet size) for batches and the lesser of batch size or 250 MB...

Yes... there's a huge problem... you have a double nested correlated subquery in the SET clause... and THAT will be executed, in it's entirety, once for every row qualified by...

... and that will work, also... although it's a bit uglier...

DECLARE @date DATETIME

SELECT @date...