This is now the third time I've had to use this article as a reference for moving the same database. 4 different data centers for the same database. ...

Resolved- problem was between my keyboard and chair.

The 30 characters should have been a clue.

I had defined my variable for the SMS/SMTP address as VARCHAR(30) but the DB...

Thank you for your response and for the link. It was a good read and it does help.

The timeouts that are being logged are being logged by processes on...

I should indicate also that there are no messages logged to the SQL Server Logs during this time.

I do not see errors in the database event logs during the period of time VSS is running.

I see normal messages:

1) The Volume Shadow Copy service was successfully sent a...

I agree. I have a slew of date functions that calculated dates. In the end I just used them to put the dates in a calendar table (I...

Jeff Moden wrote a very good article on this table

http://www.sqlservercentral.com/articles/TSQL/62867/

He has a number of articles that have proven very helpful to me.

Not at all, I come here primarily to learn, and to try to help others out if I can. Thank you for the link. Again, another good article...

Thanks Jeff, good article. My solution definitely fits into that category and would probably only work for a very limited number of rows...not a good solution.

With that said, and...

-- SET UP A TABLE VARIABLE WITH ROW ID FOR ORDERING

DECLARE@Sales as Table(

RowID int IDENTITY(1,1),

Statement_num int,

Fees_Due smallmoney,

Initials char(3),

Fees_Billed smallmoney)

-- INSERT SOME TEST DATA

-- IN THE SAME ORDER IT WOULD COME...

Since the year always starts on January 1

DECLARE@Year int,

@Date datetime

-- SET UP THE YEAR

SET@Year = 2008

-- SET THE DATE EQUAL TO

-- JANUARY FIRST OF THE YEAR

-- ADD THE 1...

Why wouldn't JNR receive 88.34, GTC receive 3761.74 and BCB receive 3864.59? Or, why wouldn't BCB receive 7634.67 and JNR and GTC receive nothing?

How are you determining which set...

You're right John.

In my haste, I again did not account for the first few days of the year if January 1 does not fall on a Sunday.

Please see:

DECLARE @Week int,

@Year...

Jack, I believe you are correct. I should not subtract 1 from the week. If I do, then Jan 1 - 5 technically would not have a week...

I recently had to perform this same function to convert data that I was storing by week back into dates for reporting.

Here's what I came up with:

DECLARE @Week int,

@Year int,

@Date...