Thanks! Will check that out.

Yeah, which we supplied in the setup for Control-M. Documentation on this product is just about the worst I have ever seen.

Versatile,

I'd guess it would be possible. However we have not had a need for it so I have not tried it. Take a look at the source, or...

Grant and Eric,

I would bet you are right about ANSI settings. Didn't even think of that!

Not sure how much control I would have over that with Reporting...

It is, see end of first paragraph.

Notice that the article referenced above mentions PCU1, after installing Service Pack 1 changing the URL makes Report Builder 2.0 work.

It looks like the install of the Report Builder stand...

sidni (6/18/2010)

---

I have tried this and it seems to work fine, however it does not recognise excel when I tried to open although it opens it and my main point...

For what it is worth...

I have seen this behavior in a few different cases now with queries with CTE's. Small rewrites, can cause large changes in CPU time, but...

Perfectly! I knew I was just missing one little detail in my thinking! Thanks.

My guess is that you are getting the detail records right after the header record they belong to. If not, the data would make no sense no matter what...

oh I know I am getting the wrong result. I messed that part up (since corrected in the ad-hoc code this was from). What I do not understand...

Josep,

I have been on a project like that before... We had a situation where the SAP people refused to give us the needed security to load data directly from...

Rob Fisk (12/4/2009)

---

See, where I will find this really handy is the following scenario...

SSRS report with multiple tables. Two summaries and a detailed list for instance.

When a user exports it...

True, but, at 7:32 in the morning.....

Honestly though, if I was going to import Excel files back in to SQL (or programmatically into anywhere) I would use SSIS instead of...

Josep,

I don't have that situation here, I would just transfer the data directly from SQL to SQL. The solution should be obvious! ImportFromExcel.DLL !!! Get to it...