Rough guess? The LEFT JOINs were chained, so a previous LEFT JOIN was acting as a restriction on a deeper one.

Need to see the query to be sure though.

Lynn Pettis (6/13/2014)

---

Actually, I might be next year. Keeping an eye on SQL Server opportunities in Colorado Springs still and there isn't much there. Phoenix and Kansas City...

Offhand, even in my warehouses, I never really saw a significant value in storing the date as a four byte int instead of the 8 byte datetime. Yes, I...

John Fager (6/12/2014)

---

I'd say that when there is a book almost the size of the Bible describing just "Inside the SQL Query Optimization Engine"... um that's where we are in...

Lynn Pettis (6/13/2014)

---

Sean Lange (6/13/2014)

---

You should get out and play. That...

Heh, Grant...

I just literally rolled out of bed. 🙂 I love this contract.

Good game today though?

Most of them understand the nature of the business. There's no 'bench' anymore, where you're paid between work. Because of that, they really shouldn't try to hold you.

Robert...

Contracting for most of the last 10 years now.

Watch out for a particular thing Robert Half will do if you're not careful. They market your resume before contacting you...

I prefer not to use BEGIN/END on my procedure block, but I do trail the script for it with a GO so I can be sure of the termination point...

This 'war' started before I became a DBA/Dev. I didn't start my career, really, in tech until around 2001 when everything had burst and was already on a downhill....

rinshadka_2445 (6/11/2014)

---

Hi,

I have an instance in Amazon EC2 and need to be Hipaa compliant. I have few doubts,

1. Should I need to do a block level encryption of the...

This is correct.

The names should correspond to parameters fed in your Data Source. Their screen position and/or order in the list...

Sub,

What performance concerns are you worried about from the concatonation technique? You should see little to no performance difference for a concatonation technique vs. a more standard FOR XML...

You misunderstand. I'm recommending you use the SSIS loop to fire the command line, not ignore SSIS. Execute Process Task or a Script task.

Fire the packages off via command line and let them ignite as a 'shell'. That will keep the program from waiting for completion before moving to your next component....