From what I see, all you need to do is to remove the first table previous to the comma. I did so below. Since they were both aliased...

From my point of view, since there are not any DDL triggers that handle job and job history and you cannot add triggers to system tables, you are really only...

Not sure if these are your only problems, but there are too many case keywords in your query, plus way too many elses. I also noted that the first...

A couple of things to remember on availability groups. These groups are cluster resources themselves, and thus each server must belong to the same cluster (remote servers are allowed).

Since...

Talk about job security, I feel like I have been doing hand to hand combat versus CRM 2013 and it's deficiencies for 2 weeks now.

Here are some of the things...

Yes, I use Ola's index tools to work on things.

What I do is dump the output to a table and keep watching things, and adjust the fill factor on the...

Things are still not much better in CRM2013, as I hae been supporting this CRM instance from CRM 4 to now. Just finished a dual hop upgrade from CRM...

I agree, CRM code is bad. So since the sp_executesql was parameterized, and one of the parameters was the filter field of the filtered index, and...

Hold the control key - and hit zero.  Exit the cell to make sure that it changes to null.

Darren,

I spent a lot of time doing what you have asked at my last job, and found that there are only really a few ways, and they depend on the...

While you can create three seperate datasets for each item you need, you can also use the following query. 

DECLARE @Table1 TABLE (col1 VARCHAR(50),col2 VARCHAR(50),col3 VARCHAR(50),creationdate DATETIME)

DECLARE @Table2 TABLE (col1...

Vasc,

DECLARE @sort TABLE ( [Value] varchar(100))

INSERT INTO @sort VALUES( '1dd')

INSERT INTO @sort VALUES( '1')

INSERT INTO @sort VALUES( '1x4')

INSERT INTO @sort VALUES( '1cc2')

INSERT INTO @sort VALUES(...

Have you thought about rebuilding the app to not depend on this identity?  That would be the first choice.  Failing this, and believe it - that is by far the...

Thank you again, sushila.   And you are correct, the Select Should be as you stated it.

Now...

Just be forwarned - I despise cursors - and kill them any chance I get.

In any situation that that seems to require cursors - a table variable populated with the...