You could use Jeff Moden (& the community) Splitter[/url]

Along with Cross Tabs[/url]

There's not enough information on your post to give you a real answer.

We can't see your data.

However, I would recommend you to examine this:

select

CONVERT(varchar(30),clx.prdt) as ADate

from EXPM clx where...

Anyone is going to SQL Saturday 151 in Orlando?

I would like to meet some of the people from SSC.

Chad Crawford (9/21/2012)

---

Luis Cazares (9/21/2012)

---

Chad Crawford (9/21/2012)

---

For our app we are going to go with a generic "Phone 1", "Phone 2", etc. up to a "Phone 7" and...

Chad Crawford (9/21/2012)

---

For our app we are going to go with a generic "Phone 1", "Phone 2", etc. up to a "Phone 7" and store each in it's own...

Let's begin:

Agree, that's a...

It's hard to understand what you're trying to do, I hope that you can help us to help you.

As Sean said, SUM() will only allow one parameter.

I've made some changes...

It would have been great to understand the difference between row-by-row programming and set based programming (or procedural language and declarative language). It would be important to notice when is...

All the opinions are valuable, either if they're correct or not, as everything is an opportunity to learn.

Regarding the beating, there's something in Wikipedia about...

Lynn Pettis (9/20/2012)

---

SomewhereSomehow (9/20/2012)

---

CELKO (9/20/2012)

---

don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin skin,...

Maybe this can inspire you 😉

Gallery

Eugene Elutin (9/20/2012)

---

Luis Cazares (9/20/2012)

---

Eugene Elutin (9/20/2012)

---

jcrawf02 (9/20/2012)

---

Eugene Elutin (9/19/2012)

---

Jeff Moden (9/18/2012)

---

Easy, big guy. You're right but that's something that he would say....

The instructions are mostly generic as VS 2012 is independent of SQL Server.

You can follow the instructions here: http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa if you don't feel confident to use the SQL Script files...

My opinion has nothing to do with my capabilities.

At the time, I don't have any work to do, so I treated this as a challenge for me. Others might not...

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a good advise.

This might cause others...