Linda 44925 (11/9/2010)

---

Thank you for clerifying the JOIN issue. I do recall studying that the method of creating joins had changed recently but I'd never worked with the old...

Please post the deadlock graph.

SSSolice (11/9/2010)

---

Hey thanks for the reply.

The break scans are actually a single table. The actual table contains millions of rows with many scan-types (I just need the 3 and...

GilaMonster (11/9/2010)

---

I know someone who's still forced to work...

😀

Interesting changes to the MCM program:

http://www.sqlskills.com/BLOGS/PAUL/post/Big-changes-to-the-MCM-program-and-how-SQLskills-can-help-you.aspx

;WITH CTE1 AS

(

-- put the on/off breaks together, along with just the date of the break

SELECT AssociateGUID, ScanCode, ScanDateTime,

ScanDate = DateAdd(day, DateDiff(day,...

They are aliases. One is for a table, one for a column.

@craig-2: +10! Great job in helping to educate!

Marcus,

Let me try to simply explain.

An index is on multiple columns - in your case, EmpNum and...

It appears that I didn't explain properly... the triggers should not need to be disabled. In fact, they are probably performing something that is expected to be happening. If you...

No problem. Do you understand why the first method won't utilize the indexes?

Wow. If my company was like that, I'd be running for the door.

tmitchelar (11/9/2010)

---

Linda 44925 (11/9/2010)

---

I’ve never done any work with CTE’s before and I would very much appreciate it if you would give some more detailed explanations of why you changed...

Sachin.Nandanwar (11/9/2010)

---

bitbucket-25253 (11/9/2010)

---

Is this what you are seeking:

SELECT DATEADD(mm,-3,DATEADD(day, 1, GETDATE()))As '3 months ago',GETDATE() AS 'Today',

DATEADD(day, 1, GETDATE()) AS 'Today plus 1 day'

Results:

3 months ago ...