Roy Ernest (6/28/2011)

---

Congratulation. Well done. I will never hit 3K for...

Also, if you are serious about learning about SQL Server and have some money available, look into purchasing the Developer Edition. It costs about $50.00 (less if you shop...

If you are going to throw out 3rd party compression programs, how about 7Zip (which is free).

I am glad that this old thread was of use to you, and I am glad my routine was useful as well.

Thank you for feedback.

Please take the time to read the article previously referenced (happens to be the first article I reference below in my signature block). Following those guidelines will get you...

Highly agree with Sean. The set based delimited split function is much more efficient and scalable. Definately...

datediff(day, case when ia.eventstartdate < @startdate

...

Steve Jones - SSC Editor (6/21/2011)

---

Lynn, your reply on the "code provided" was fine. Maybe a little short, but not worth complaining about. Just a note, from my side I...

Stefan Krzywicki (6/21/2011)

---

Lynn Pettis (6/20/2011)

---

Craig Farrell (6/20/2011)

---

[rant]

AAARRRGGGHHH....

One more person, just one more, who applies for an SSIS position (it's specifically advertised as an SSIS position) who's done nothing more than...

Agree with posting the actual execution plan, but I post both (with and without the forceseek).

My guess is that the query optimizer believes a table scan to be the best...

Really?? (different person). Hope I wasn't too harsh in my reply.

Code provided, you test it.

It's late and I have to get up early for work this morning.

Not much better here either. Would help if he would figure out how to make his urls he posts clickable. I don't feel like showing him, though.

Really? What an enlightening answer. I just can't think of anything else to say.

Hope this helps. As you provided nothing to develop the code against I give no promises that it will work as you desire.

with EmpChecks (

CheckNumber,

...