Krypto, that would be difficult for us to answer...

Lynn Pettis (6/8/2012)

---

You have to be kidding me.

OP: I don't want a union. How do I put these two queries together?

Me: Looks like you need a join.

OP: ...

azdeji (6/8/2012)

---

Thank You For the Comprehensive Reply!!!

Can you help me with one more question releating to folders and Variables?

Is there any way to retrieve the folder name for...

Revenant (6/8/2012)

---

GilaMonster (6/8/2012)

---

I've heard mutterings about using Kinect for that. With it's facial recognition it can lock the computer when you get up, unlock when you sit down.

Would probably...

Greg Edwards-268690 (6/7/2012)

---

Stefan Krzywicki (6/7/2012)

---

Revenant (6/7/2012)

---

For an intermedaite or senior BI developer, I would probably add "understanding of business statistics." By that I mean a good grasp of applicability of...

What you're looking to do is really return two different recordsets. The first query in a union defines what the field types/names/etc are. This is what we call...

Stewart's method is about the only way in pure T-SQL to perform that task, using IsDate() and then converting or returning null based on the result of IsDate().

Just make sure...

I wouldn't avoid using views, I'd just make sure I understand the limitations of them. The reason...

GilaMonster (6/5/2012)

---

I love the fact that my bank keeps offering me an overdraft¹ at reasonable rates, even though I have more than 5 times the overdraft amount in my account....

We don't have the UserProductivityMapping INNER JOIN Weeks wk...

Can you copy/paste the result of your print statement? I believe the error's most likely in that, not in your actual...

The method you want is either a Crosstab query or the PIVOT function, but the problem with both of those is you typically want to know how many columns you're...

ScottPletcher (6/4/2012)

---

@scott: By best practice you never store your unencryption mechanisms and your data in the same place. Admittedly, there are times when you may need to work with the...

blampe (6/4/2012)

---

As for defining the purpose of this script a little more clearly, this whole thing is being used in an incredibly simple manner. I know that giving users the...

Not a problem, particularly since you're looking to help yourself and not...

Jeff Moden (6/4/2012)

---

ScottPletcher (6/4/2012)

---

When you create a clustered index, SQL itself will make it UNIQUE if necessary. A clustering key in SQL Server is always UNIQUE -- it must...