Can you post exactly what your need is? It looks like you want to select the 15 characters after a "/", is this correct? If your SELECT statement...

I think the answer you want is in the article[/url] featured in today's newsletter and on the front page of the site.

Select the textbox/item where you want duplicates to be hidden -> right-click -> select properties. Then find the Hide Duplicates property and select the dataset for which you want...

Don't forget the Duct Tape!:-D

I think this code does something similar to what you want. It is a split then pivot which you said you tried. It assumes that you have 3...

Where does a row stop in your example data?

How do you want the data returned?

It looks like you could do a "simple" split to get it in rows and then...

You just need to be careful with the table variable as there are no statistics for it so the optimizer assumes 1 row. It works well with small datasets,...

I'm glad that Gail is back today. She seems to be spending her day...

Thanks for correcting me Gail.

Can you post some sample data? See the top link in my signature for suggestions on how.

Sure you can restore a backup from a 64-bit server to a a 32-bit server. The file formats are the same.

Thanks for providing the test data. Can you be more specific about the data you want returned? Do you want results like this:

Code RetailPrice DateFrom...

Okay, so the specific query results are NOT cached, but the data pages that are required to fulfill the needs of the query are cached.

Gail,

Thanks for the clarification. I was, obviously, assuming single column stats.

I'm going to venture a guess and say that you are experiencing a permissions issue. From BOL:

If the caller of sys.databases is not the owner of the database and...