What version of SQL Server are you using?

Looks like selecting 60 days of data and a pivot to boot. Am I correct?

YSLGuru (12/16/2009)

---

Drew,

Thanks for replying and I know this is a few months old now (Just now getting time to go back and deal with this one) but unfortunately that will...

Kit G (12/16/2009)

---

GabyYYZ (12/16/2009)

---

Grant Fritchey (12/16/2009)

---

Whoa!

From what I can see this person has tried to demonstrate some work, but good googly moogly, who is going to read all that stuff...

First, save MIS some money, use Microsoft SQL Server instead of Oracle!

We are a Microsoft SQL Server forum, after all. 😉

dpt (12/10/2009)

---

I upgraded a server from 2000 to 2008. For the most part, everything has gone fine. There is one issue. We have a number of long...

Instead of mapped drives, you should consider using UNC's to access remote files.

Confused. Why not show us what you are trying to accomplish.

If the setup didn't ask you to provide an sa password, it sounds like you setup SQL Server to use only Windows Authentication, is this true?

No, but SQL Server 2008 does provide data compression at the ROW or PAGE level on a table by table basis. I am looking at this myself right now....

Since TDE is not available in SQL Server 2005 and I am not familiar with log shipping as we aren't using it. Here is my two cents. If...

First, it isn't that it is a primary key but that it...

It would help if you provided the DDL for the table and the trigger, as well as some sample data with expected results. You can get some help with...

Glad you solved the problem. Proper forum etiquette, however, is for you post how you solved the problem. Others may have the same or similar problem and seeing...

Jeff Moden (12/15/2009)

---

What you're missing with the CASE method in the ORDER BY is that if another city is required, you now have to change code.

Make a table with the...