WayneS (11/1/2010)

---

But... you could have a different problem.

If your job is scheduled to run, say, every 15 minutes. When it runs @ 1:45 (the first time), it gets set to...

george sibbald (11/1/2010)

---

Stefan Krzywicki (11/1/2010)

---

Thank you both for the helpful information. Now I can go on vacation this weekend without worrying. : -)

George, where are you that you've already had...

WayneS (11/1/2010)

---

Stefan Krzywicki (11/1/2010)

---

I was torn about whether to post this question here or in the forums, but settled on the forums because it might help other people too. Still,...

jcrawf02 (11/1/2010)

---

Tom.Thomson (11/1/2010)

---

There could be a similar interesting question about the other daylight saving time shift shift (in 6 months time). Will jobs scheduled to start between 0200 and...

Alvin Ramard (11/1/2010)

---

Stefan Krzywicki (11/1/2010)

---

Thank you both for the helpful information. Now I can go on vacation this weekend without worrying. : -)

George, where are you that you've already had...

Thank you both for the helpful information. Now I can go on vacation this weekend without worrying. : -)

George, where are you that you've already had daylight savings?

I was torn about whether to post this question here or in the forums, but settled on the forums because it might help other people too. Still, it is a...

Have you had any previous versions of SQL Server installed on this machine that have since been removed?

Thanks for all the work Gail, that's a lot of help you've provided.

mbender (10/29/2010)

---

Ya i guess i really don't know the difference between a temp table and a variable table. I like using Variable Tables cause they are like a scratch...

Lynn Pettis (10/29/2010)

---

I really think that the code can be much simpler. I'll wai for the OP to post the DDL for the underlying tables, sample data, and expected...

I didn't have any data to run it against, but this is the kind of look you're shooting for.

CREATE PROCEDURE YourProcedureName

-- Add the parameters for the stored procedure here

@MonthDate date

@Office...

WayneS (10/28/2010)

---

Stefan Krzywicki (10/28/2010)

---

Roy Ernest (10/28/2010)

---

I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with...

Roy Ernest (10/28/2010)

---

I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with the indexing.

You also...

Craig Farrell (10/28/2010)

---

Think this would be a bit much as my signature?

CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT

AS

-- Go read the documents, inline comments are for sissies.

IF EXISTS (SELECT...