Thanks for the response Phillip.

We will be implementing a hybrid of Type 1 and 2.

For each of our dimensions we have identified attributes that will trigger a Type 1 update...

Thanks Norman. Glad to know it's possible.

The SP actualy returns 14 result sets. The procedure has been written by a third party which mean I have no control...

Brilliant... thanks guys.

Thanks Steve

Nice article.

Has anyone got any examples of similar XML output but with header information included.

Following on from Jacobs article and presuming the existence of an OrderHeader table, the output would...

I had an issue (as noted earlier) with the BCP solution. It worked fine with PDF binary store but not for any other file format - tif for example....

I have tried the above but have run into an issue.

The table holds an image field containing either tiff, jpg or pdf.

The code works for pdf but the...

Thanks Martin & Nebjosa,

Looks exactly what I need. I will try it.

Ta

I have a table with many rows, each containing an binary field containing, basically, an image. I would like to query this table and produce a file on disk...

Thanks for the info Andras.

Interesting article.

Thanks for your post Matt. Usefull info that I will take on board.

Ta