More garbage from BoL, and trivial to test and prove false.

Now, maybe they shouldn't be running in parallel, maybe there are missing indexes, maybe there's badly written code. Either could...

With the network down, you won't be able to do a controlled failover.

If the connection between Site1 and Site 2 drops, principal will go offline (it doesn't have quorum), Mirror becomes new principal.

I'll second the suggestion of Lightswitch if you have no development experience. Learning to write a front end app from scratch is well beyond a forum step by step.

Then you should have mentioned that in your requirements. I can't read your mind.

Replace the LEFT with CharIndex with just a LEFT(3), and the CASE checking for LEN >=3, assuming...

Rollup generates a grand total row, which was not asked for. Easier to use Grouping Sets to just get the totals needed than...

Jayanth_Kurup (9/7/2015)

---

Find and replace will change the varchar to nvarchar but you still need to account for the increase in the column width now. I think dynamic sql might be...

Thanks for the sample data

This does what you asked.

CREATE TABLE #accounts (

AccountCode NVARCHAR(10),

AccountName NVARCHAR(50),

Total INT

...

Sure

EXEC sp_start_job

It takes the job name or ID, server name and step to start the job at as parameters.

You cannot pass a parameter directly to a job, because jobs are designed to be run automatically on a schedule without user input. You'll have to do some workaround like...

Without a CREATE TABLE to easily test with (and it being around midnight), I suggest you read up on Grouping Sets, it should allow you to do what you want.

Please post create table statements and sample data in an easily usable form (insert statements). Personally I'm not going to download and open a strange excel file.

To test this kind of thing, you need to have multiple batches, not a single batch with lots of statements. The reason these kinds of queries perform...

https://msdn.microsoft.com/en-gb/library/ms187819.aspx