S'ok... just proves one thing... memory is one of the best things you can do to speed up a machine. Thanks for the feedback, Remi.

Heh... your surprise, Remi, is that your particular computer sucks at handling strings... the results you provided are WAY out...

gyanendra.khadka (9/12/2008)

---

Lynn, FInally Got IT. But for one FTP process I don't thing they would like to do it. ALso, on my side I only have one ssis packages to...

Thanks for the great feedback, Carla. If you want a bit more on splitting things, take a peek at the followup article below...

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

By the way... if you actually take the time to run the code above, I think you'll be very surprised as some of the outcome.

"LIKE" has gotten a pretty bad reputation just by word of mouth. Might be left overs from the early days of SQL. Glad to see some folks testing...

Dang... as luck would have it, I found a reason to actually nuke old spids... connection leaks. I recently started a...

No extensions on the file names?

Here you go, Jody...

--===== If the temp table already exists, drop it.

-- This should be commented out in a production environment

...

Manie, great primer on PatIndex!

There is hundreds of other ways to use these functions and the way I used here is most probably not the best way so, if anyone...

One of the folks on this very forum said it best... "The extraordinary DBA is the first person someone goes to when they need help, not the last." Sounds...

Thanks for the awesome feedback, Hans. You made my day. Just remember, the Tally table is not a panacea... it cannot be used for all things that loop....

On the other hand, look at the bright side... 🙂 They have such a crappy DB that they need someone like you to wade through it and fix things....

Jody Claggett (9/11/2008)

---

...but it looks like your code sample is suming the data based on the fiscal quarter.

What I am looking for is to sum the YTD quota up...

Whew! Thanks for the feedback, Fraggle. Thought I missed something:).