I need help with the subtotal rows. I want to add the GLAMount from previous row AS Sub-Total and Total on the last row is the addition of all sub-total.

SELECT 1 AS ID, '1    Cash on Hand - Local Currency' AS ROW_CATEGORY, COALESCE(SUM(GLAmount)/1000,'0.0')  AS GLAmount
FROM v_GL
WHERE GLBSAttribute7 ='1. Cash' and GLCurrency ='SAR'

UNION

SELECT 2 AS ID, '2    Checks...

its in spreadsheet and I am developing an SSRS Report for it.

Hi Phi,

I am trying to write the code. I only have a spreadsheet. I haven't got any DDL to send. Please, find attached the sample report. I want to add...

We use SQL Server authentication and I checked saved password in the configuration manager but yet, the package run successfully in bids then but not in SQL Server. Are you...

Thanks. I found it already and it worked. The problem now is that it is asking for password each time you want to open the package and it also did...

Koen,

Many thanks for your response. How and where can I view this property?

Once again, thanks.

Sahoong

Hi Arthur,

Just stopped by to say 'A BIG THANK YOU'. You broke this down to me and introduced me to XQuery. This is my query now and it is working...

Hi Arthur,

Thanks for introducing me to XQuery. Unfortunately, my knowledged is not enough to handle the data that I am pulling. The next one that I am pulling is nested...

I have ammended it as below and it is now picking EmployeeID as well. Thanks and God bless. I will give you a shout when I get to other section...

Thank you so much. I really don't know what to say but you have basically did this for me. I have ammended the query as a SELECT INTO to dump...

Hello. Thanks for your help. Some section of the codes didnt work but I have been reading your blog and some other articles on xquery. I will tell you what...

Thanks so much for your help. The query completed successfully but where is the formatted xml get dump? i want to insert it into a sql server table. right now,...

Thanks. The storing in variable works fine but now that I have a better understanding of the process, I am getting confused with the file response you wrote me...

Thanks ever so MUCH. I really appreciate your help.

SELECT @xml.query('

<Workers>

{

for $x in //d1p1:Worker

return

<Worker>

<EmployeeID>{$x/d1p1:Worker_Reference/d1p1:ID[@d1p1:type="Employee_ID"]/text()}</EmployeeID>

<FullName>?? unknown ??</FullName>

</Worker>

}

</Workers>

')

If I have my data in a file and I want to run the above...