Yeah, why am I not using the Year Function.

Lynn Pettis (10/23/2015)

---

Something like this?

SELECT

DATEPART(yyyy,tc.Call_Date) AS ArchiverYear

FROM

dbo.tblCall tc

INNER JOIN PrismDataArchive.dbo.ArchiveDriver AS Arch

...

Michael L John (10/23/2015)

---

I'm not asking you to hard-code the year.

I asking you to query the table and see if any records exist in the table that match...

Michael L John (10/23/2015)

---

Since the deletes are based upon...

Michael L John (10/23/2015)

---

Run this code and see if anything comes back:

SELECT DATEPART(yyyy,Call_Date) AS ArchiverYear

FROM tblCall

WHERE Call_Date <= '01/01/1900'

If not, there are no records in the table with...

Michael L John (10/23/2015)

---

Run this code and see if anything comes back:

SELECT DATEPART(yyyy,Call_Date) AS ArchiverYear

FROM tblCall

WHERE Call_Date <= '01/01/1900'

If not, there are no records in the table with...

I'm rewriting it.

When I close the Window I get a popup that there are open transaction.

This thread is over 3...

Please close this thread and put this puppy to rest.

Thank you.

That is what I thought.

Thanks.

It finished while I was writing my post.

ok, it was September 29th.

I have been working around the clock for two weeks 7 days week.

Sorry about that.

Michael L John (10/5/2015)

---

Do yourself a favor. Invest in yourself.

Look at this site:

http://www.sqlservercentral.com/stairway/72401/

Read this series. Almost all of your questions are answered in this series.

There...

I was looking in the wrong DB for the file.

I was able to add 1 article that I needed and I'm set to add over 1,00 plus. 600 SP' plus...