for the Amber thing, just do a replace command to remove it before you format the date Replace("Amber", "")

It's been awhile since I logged on to SSCentral and unfortunately I have not been getting the from the people requesting new information. The basic premise of this stored...

Colleen, that would do it as well. I had something like that at first but I just realized I didn't qualify my actual lunch dates correctly.

I'm going scalar. In fact I've already finished it and it works great. Definately beats the cursor and RBAR. Jeff Moden would be proud of me 🙂

MM

For line one, I'm expecting to get the return of 30.

I get that result by adding the number of lunches served within the two year period of 2010-06-01 which results...

That doesn't take into the need of it being a two year average based on the Actual_lunch_date. However it is very interesting.

Have you thought of doing a script task to check the last row and delete it if it is not complete

Unfortunately you may be at the stop and start services point now. Of course the db will probably come up suspect, but you should be able to either delete...

First question, why are you backing up to a network drive because 2005 does not like that. Better to backup local and then move across the network.

Second: Which...

Sorry

Been busy and haven't been around on a regular basis, let me know if you still need it and I will dig it out.

Thanks

MD

Jeffrey

Your plan is sound. However, in the orignal post, they were backing up the file over the network, not to a local drive first. So all posts were...

Jeffrey

I did go that route one time, but was not very comfortable with it. Mapped shared drives still involves a network and I have used them to copy files...

Unfortunately not. It must be direct attached storage or any little glitch in the network will cause your backup to fail. I have used a large capacity USB...

Shri

I sent you a new script. Let me know if that works for you

MD

I definately about storage on the file system vs MSDB. I think the file system is much cleaner and I actually have some SSIS packages that has nothing to...