This is part 2 of a set of articles written by Jeff Moden. It covers dynamic cross tabs: http://www.sqlservercentral.com/articles/Crosstab/65048/.

Check it out. What ever you do, it will start...

Jack Corbett (7/21/2010)

---

Grant Fritchey (7/21/2010)

---

Lynn Pettis (7/21/2010)

---

Steve Jones - Editor (7/16/2010)

---

...

Not sure it will help, but that, along with a lovely complaint about Mr. Celko has made this a less...

Never met Mr. Celko,...

Joe Celko (7/19/2010)

---

>> The function below is used within a query to get the last 10 days data. The query runs very slow even though there are indexes on the...

Looks to me that answers should actually go here, not in the other thread since the OP is using SQL Server 2005.

I concur with Ray. Full and Differential backups do not break the log chain.

Have you tried this:

select

cast('' as char(3)) as sno,

name,

comments

from xyz

Okay, I have run into a small issue that I am wondering if others may have had with BIDS 2005 and BIDS 2008 installed on the same client machine and...

Not comparing what I had for lunch today with Memphis BBQ, but I had an awesome Pulled Pork BBQ sandwich (Hot, as in spice BBQ) at the Farmers Market today.

Better...

Grant Fritchey (7/16/2010)

---

Lynn Pettis (7/16/2010)

---

I guess some people think it isn't unprofessional to call someone stupid in professional site such as SSC.

I hope I wasn't ambiguous in my last response...

I guess some people think it isn't unprofessional to call someone stupid in professional site such as SSC.

I hope I wasn't ambiguous in my last response to this particular individual.

Gail,

Call me a spoiled American, but if it were only 46F in my house in the middle of the winter, there is a serious problem with our furnace and we'd...

doobya (7/16/2010)

---

I gave him a way out by asking him if he was pretending

He chose not to take the way out

I even proved he was stupid with working code

Which he...

doobya,

Just a couple of thoughts.

First, I take exception with your statement "Finally, somebody understands...". Hate to break it to you, but I understood what you were saying from the...

Agreed, work has kept me busy too. May be starting a new job in August that should actually open up my evenings and weekends some.