Yeaup... still RBAR... but the Tally table get's cached... While loop doesn't. 'Course, you knew that.

If you don't like the Thorn character (used it mostly for visual), Tab character...

The problem is the Cross-Apply's... they resolve to a single row in the execution plan. Query may run ok when running from QA because of cache and stats... likely...

karthikeyan (9/17/2008)

---

How should i split double ~~ symbol into two ?

I hope i have explained enough. Inputs are welcome !

Also i wanted to know whether the way which i...

A bit more info is required... please see the link in my signature for faster, better, tested answers....

Dunnor if it works in Integration Services, but I Use STUFF to quickly add a couple of dashes.

--===== Setup a simple test.

-- This is NOT...

When "rebuilding" and index, the index is NOT available for use. That is also true when using DBCC DBReIndex. They are, however, available if you use DBCC IndexDefrag.

What a cool thing to say, James. 🙂

Ummm... what are you calling "high consumption"? How big is the MDF and the LDF file for TempDB right now?

See the following... it's a long article, but it's worth it.

Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

http://www.sqlservercentral.com/articles/T-SQL/63003/

THAT's the way to do it... no RBAR, no join! 🙂

ishmael (9/17/2008)

---

Re: Peso - this is a clever and quick way of doing it, and works well (needs a GROUP BY PartyID at the end) - however will demand significant...

You might want to consider using 4 digit years and, possibly, a date format where the month and day cannot be confused... for example, is 06/07/2008 June 7th or July...

Google search turned up about a million hits on this error. Here's the KB article from Microsoft that turned up...

http://support.microsoft.com/kb/225782

You're welcome. How did you find the bad data?

Thanks, Lynn.

Scott, the article is long because it explains the wrong way to do things as well as the right way. The concept is wicked simple and creating running...