Here is a script that was posted by ChrisM. I modified it slightly to make a little more bullet proof. This will generate the code you need to run. It...

pietlinden (2/2/2014)

---

sure enough... must be getting old... forgot that my Tally table is indexed, so that caused me to overlook it.

Definitely need an ORDER BY clause! TOP VALUES without...

We are not here to be unpaid consultants. We...

It will pretty much always outperform a traditional PIVOT. See this article...

Steve Jones - SSC Editor (1/31/2014)

---

In line with Sean's issue. If a few of you want to write this up in a slightly more formal way to note that it's...

Nice work Alan. I too suspected that an inner join could (and probably will) not produce exactly the right results. Of course in our business accuracy is the first requirement....

sqldriver (1/31/2014)

---

Hi,

I've been writing queries using

SUM(CASE WHEN SomeVal = 'X' THEN 1 ELSE 0 END)

And today looking at some code I saw someone do

CASE WHEN SomeVal =...

Probably true. I didn't put much into since it is late on Friday afternoon. 😛

Not 100% certain what you are looking for as you didn't post a lot of details. It would be very helpful if you could post ddl and sample data in...

hayden_jones (1/31/2014)

---

As far as I can see, the results-to settings are not saved even for the same windows login.

I log in to windows as DOMAINA.userA and open SSMS using...

hayden_jones (1/31/2014)

---

I have a report to run every day in SSMS. I have selected query options to send results to a file with pipe delimited results. Tomorrow, I...

Research, analysis, testing.

There is no "easy" way to do this and each one requires a unique process to remove it. They just have to be dealt with one at a...

VoldemarG (1/31/2014)

---

so from everything I heard/read, would that be fair to conclude that option 2 is the way to go in the majority of cases?

2) where databasename ='myDBname'

and applicationname...

wolfkillj (1/31/2014)

---

Ed Wagner (1/31/2014)

---

I especially like Kimberly's article Luis posted here. Sean,...

damcguire (1/31/2014)

---

This syntax works fine to create the table, insert the data, and delete it... but will not work against my actual db field/data. Syntax I used and errors above...