Without the original data, how can we hope to get the results your after? Could you please post DDL and consumable sample data?

Thanks.

You should know that you need to supply data with DDL and in a consumable format.

Extended support still exists. Otherwise...

Your post doesn't make a lot of sense here. Firstly the query Select Sum(Amount) from table1; will return a result set with a single row and single (unnamed)...

Ahh, ok. If it's converting into a CSV then this will work (using STUFF and FOR XML PATH):

I almost think the OP is looking for a generic tool for every scernario, i.e. making their own LAG/LEAD function. That isn't going to happen.if you wanted to use a...

This isn't going to be a pretty join no. I don't see any reason to split into a Temporary table though, do the job in one go:

You could have a look at PowerBI, but, personally, I think SSRS would be a good choice here. if it's on a separate machine, you only need a web browser...

Depends how you want to display it, your requirements are quite vague. For example, you could use Excel. Run the script in SSMS, copy and paste the data out into...