Go to Dice or any tech-oriented job site and look for jobs... and see what you find.

Oh, cool!  I knew there had to be a less messy way of doing it! Thanks!

Looks like you missed the CREATE TABLE part of this script...

Any chance you could post some CREATE TABLE and INSERT scripts so we can all play with the same data?

Please explain what records you want from Table B. An outer join returns nulls from Table B if there are no records that match those in A.
Compare
SELECT a.Field1,...

Only way I can think of getting this to work would be to add a running total in your query.... if that's not an option, then this could get ugly.

What are you going to use this for? I'm asking because in SSRS, this is really simple. You would add a tablix to your report surface, and just group by...

You don't have PowerShell? Why not download it?

What was it? Please share!

What if you did it using PowerPivot and DAX. There are functions for that. CLOSINGBALANCE stuff, etc. Is that an option?  What did you intend to do with the data....

Got Google?
https://stackoverflow.com/questions/31153523/is-there-any-performance-difference-between-view-and-stored-procedures

Sort of an apples vs oranges comparison. They're used for different purposes. What's your end goal?

I hate to be ugly, but I really think you're over your head on this one.  E-mail Albert Kallal and see. He wrote about designing something very similar on the...

Albert Kallal wrote one of these several years ago. Or one very similar to this. Not sure if he used SQL Server as a back end, although he might have.

Sounds like homework. Pretty sure you're supposed to do it yourself.  Try it and ask if you don't understand something.

Do you mean as HTML? "This format" and showing a picture doesn't really help.