Start with this:

SELECT

ceiling(DAY(GETDATE()) / 7.),

DATENAME(dw, GETDATE()),

ceiling(DAY('20120731') / 7.),

DATENAME(dw, '20120731');

Duplicate post, please do not cross post. Post replies here.

rodjkidd (7/17/2012)

---

Lynn Pettis (7/17/2012)

---

Grant Fritchey (7/17/2012)

---

rodjkidd (7/17/2012)

---

Grant,

Good to see you are still communicating fairly normally! I guess 6 sessions in two at SQL in the City just wasn't enough to...

Grant Fritchey (7/17/2012)

---

rodjkidd (7/17/2012)

---

Grant,

Good to see you are still communicating fairly normally! I guess 6 sessions in two at SQL in the City just wasn't enough to push you over...

Very good question. Made think a bit as I knew I had read this some where. Glad I remembered correctly!

Oh, please, I need a magic bullet to identify all my orhaned records in 100's of tables. I don't want to have to work to figure it out.

Oh, please,...

As far as I know there is no magic bullet to determine what records are orphaned. You are going to have to do the work as you are the...

Orphaned data is normally considered children records with no parent records. Easiest way to identify them is to query the child table using a left outer join to the...

Scott Anderson-466019 (7/17/2012)

---

Yes, well spotted. A typo.

So other than that, what could it be that would make the SQL fail?

I know it shouldn't happen but it appears that something is...

Scott Anderson-466019 (7/17/2012)

---

Lyn:

1) The stored proc is called on each application load, but the insertion should only run once.

2) Here are the definitions of the 2 user defined types. Don't...

sufiyan.sarguroh (7/17/2012)

---

Hi,

Was just going through this thread. Really interesting.

I have a question though, does this mean that a differential backup contains the changes made in a database from the time...

Good idea for posting code, test it all in an empty sandbox database. Found a typo in your procedure and you provided a check constraint and FK that wouldn't...

Also, the following appear to be user defined types of some sort. What are the base type for them (I can't create your table as it is defined).

[dbo].[DPrimaryKey]

[dbo].[DForeignKey]

How often is the procedure [dbo].[mspResetDayNo] called for each store in a day?

Let's start fresh. Please post the DDL for the offending table (including the indexes defined), and the code for the entire procedure that is failing. When it errors,...