Thanks!

Chris

I'm sure this will sound like a really simple request by many, but is there an easy T-SQL method to pivot the results into two columns?

Chris

Living in Central Illinois, I have traveled both to Chicago (212 miles) and to St. Louis (90 miles) to attend SQL Saturdays. I know several folks who attend the...

My mistake, I too was confused about what data this view was gathering. After some further investigation, each time a violation (InspectionDetailId) is created during an Inspection (InspectionId), it...

ScottPletcher,

Getting:

Msg 512, Level 16, State 1, Line 2

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when...

Even if true, this kind of response is neither insightful nor helpful. It's like reporting a...

Try running the script that was posted on 2/22/2010 10:47:26 PM

Chris

jrlandeen (8/13/2014)

---

Then if they are necessary do they need to be met exactly the way originally defined - I've had to build the "easy" button that does 4 things at...

I work as a DBA/support/setup/and too many things to mention for a 3rd party software vendor. We've witnessed a number of our clients leave in search of that "magic...

Helpful script, thanks!

Chris

Like most in IT, my duties seem to vary from day to day and project to project. Whenever I need to be onsite with a client, I usually take...

After holding out long enough, I'm finally going to be getting a Blu-Ray player. The studios have won. :crying:

I love watching the bonus material that often comes with movies (behind...

Disgusted? Yes. Surprised? No.

When will the gender/race/religion/etc. issue finally be put down? Only when we as a community of professionals no longer tolerate it. The individual...

Looks like a really good start guys!

Don't get me wrong, I love RedGate and the tools they bring to the table are awesome. However, the Chicago SQL in the City felt like a day long...