Experts any help?

Hi experts Any help on this!!!

tried this logic will it work

AND (

(

(

(Group = 'ARM' AND Type = 'XXX')

OR (Group = 'CMO' AND Type = 'JJJ')

OR (Group = 'MBS' AND Type =...

Ken McKelvey (12/11/2015)

---

A test harness with DDL etc would be useful.

As this is a database why not create:

SELECT A.EPD

FROM YourTable Y

LEFT JOIN #Entities E

ON Y.[Group] = E.[Group]

AND Y.[Type] = E.[Type]

CROSS...

Thank you guys for the reply...yeah that date filter will be there...i have removed the comment.

So there is no way which part of predicate will execute at runtime first that...

Thanks Luis for the solution

Thanks for the reply.. I am trying to generate automated script which contain

BEGIN TRANS

Insert stmt--...

Thanks Grant for the reply... had a discussion with the client they doesn't allowed to create linked server, what are the other options available can you provide any reference links.

Louis Hillebrand (8/31/2015)

---

If the source is always a 6 character string:

Rearrange the input to a yymmdd string with two substrings.

Convert to date using CONVERT using style 12 (yymmdd)

DECLARE @D nvarchar(6)...

Shawn Melton (12/9/2014)

---

That is rather odd, because I can find the deadlock event searching through the file target for the system health session.

Lowell, I did try your change and...

Lowell (12/9/2014)

---

i've got something i'm cosnuming for SQL2008R2 for deadlocks, and comparing it to yours, my item is slightly different:

you have

SELECT XEvent.query('(event/data/value/deadlock)[1]') AS DeadlockGraph

mine has this...no "deadlock" in the...

Thanks roy let me check with this

Roy thanks for the reply

let suppose I am using Always on with Availability group for DR.

Then how to replicate back the data to PROD

What i understand from the MSDN, the anchor query which returns the input EmployeeID(base result) then the...

Sean Lange (11/7/2013)

---

Excellent job posting ddl and sample data. I wish everyone posted everything like that to make it easy!!!

Something like this should work.

declare @EmployeeID int = 285;

with EmployeeTree as

(

select...