I didn't want to use:

$oleDbConn.ConnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data

THanks.

Sorry it left them as Comma(,) delimted in the newly created csv.

I tried didn't seem to work..

function ConvertFrom-XLx {
  param ([parameter(             Mandatory=$true,
   ...

Or are you simply looking for guidance relating to how to handle queue processing and concurrency (which can be a little tricky if you have multiple instances of the same...

@Phil   I was thinking on the queue also do you have any examples or suggestions to get me started...

Thanks.

There are multiple sql agent jobs processing from the queue, but I tried to break them out so they where only picking up

individual records from the queue.

If I have records...

The processing can't keep up with the amount of records hitting the queue...parallelism ?

Based upon design do you think pulling records from the table using cursor is efficient ?

Got it...

cast((Select concat(', Format(coalesce(sum(Case When ft.Entity = ', h.Entity, ' Then ft.total End), 0),''C'', ''en-US'' ) As td

Thanks again...

THis is where I believe I need to make a change to get into the Description and the Column totals..

concat(', coalesce(sum(Case When ft.Entity = ', h.Entity, ' Then ft.total End),...

I update a piece in the Row totals section to format for Currency, but I couldn't get it to work for total amounts for each description

and column totals.

Any chance you...

Will upload shortly...

Thanks again to you Both...

Totally Awesome!!!!

Many Thanks!!!!

That worked perfect except if there is no value for a description can it put a 0(zero) than the total at the end of the line should populate.

currently if not...

Won't the header record have to be built dynamically?

Set @tableHeader = cast((Select html.hdr1 As th, ''

, html.hdr2 As th, ''

, html.hdr3 As th, ''

From (

Values ('Entity', 'Description', 'Total')

) As html(hdr1,...

@jeff  When I ran your code and seeing what @sql has in it, that's exactly what I was trying to achieve. How to you get that into an

email to be...