I have verified this works in SQL 2008 R2 as well. Seems strange that this was allowed as an option within TSQL. The command clearly states the correct...

Sorry to be pedantic on this but the answer to the question as written is 1. The DBA can only specify a single deadlock priority at a time. ...

It seems that you want to have a total not matching the underlying (preceding) rows ie having 3 staff members in CompanyA and DivisionA then showing 4 at the division...

Just a brief note.

This would be ok until you look at the "special" cases we find everyday with clients such as :

- wanting weekday/nonworking day (including national holidays) per country,...

On a fresh install of SQL 2008 SSMS with the exact code given no message appears for me. Holding CTRL and click does as described, but the non-CTRL behaviour...

This is adapted from a project I worked on a while ago using PIVOT.

create table correlate(

 ID char(2) not null,

 ColID1 int,

 ColID2 int,

 ColID3 int,

 ColID4 int 

)

create table vals(

 ID char(2) not null,

 ColID int not null,

 ColValue char(5)

)

alter...

I have done this for a customer requiring all routes through a network.  The outer query then decides the rows to show.  You can have two possible start (stub) queries...

Have a look at the script below.  It works for additions, deletions and updates.

------------------------------------- Two sample tables

create table Sep2005(

 lineID int,

 linedata1 varchar(20),

 linedata2 varchar(20),

)

create table Sep2006(

 lineID int,

 linedata1 varchar(20),

 linedata2 varchar(20),

)

If the principal and mirror server are still able to see each other the loss of the witness will not affect the principal server availability.