Please read the following for the solution to the Running Total (Balance) problem including Grouped Running Totals...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Why did you specify one table per service type instead of 1 table to hold all service types? And if employees suffer no cost, why did you make a...

Yes, a cursor can have a join to multiple tables in it... but using a cursor is usually a mistake.

Store procs don't have to return anything... functions do.

These are sweeping...

... an unless you've made the server case sensitive, there's no need for UPPER anywhere in the query.

Google for ...

sp_MSForEachDB

sp_MSForEachTable

Heh... two way street here... would you mind posting your solution, please? 😉

I'll second that... just remember that they teach ANSI SQL... nothing really advanced.

How many words are in HTMLBody and can I see an example of 10 rows, please?

I'd convert all of the WHERE IN's to proper joins and see if the proper indexes are in place. I'd also use a SELECT list instead of * to...

It's the leading comma from the XML concatenation that they're trying to get rid of.

My guess would be that returning nearly 2 million rows of a really wide table to the client has driven the client into the "swap file" mode, even if the...

A better question is why would anyone use a character based datatype to store a "Load time"?

Just an opinion... auto grow of 1MB is too small and auto grow of 10% will create 73 fragments just getting to 1 gig from the default starting size of...

The only index you can put on a table variable, is a Primary Key.

Through a bunch of testing across many many threads on this forum, I've found that, with the exception of RegEx replace, someone knowledgeable in the fine art of T-SQL can...