Viewing 15 posts - 1 through 15 (of 207 total)
for the Amber thing, just do a replace command to remove it before you format the date Replace("Amber", "")
November 26, 2012 at 9:55 am
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...
December 5, 2011 at 2:34 pm
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.
February 16, 2011 at 9:51 am
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 🙂
February 16, 2011 at 9:46 am
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...
February 16, 2011 at 8:24 am
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.
February 16, 2011 at 7:49 am
Have you thought of doing a script task to check the last row and delete it if it is not complete
December 17, 2009 at 7:11 pm
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...
December 17, 2009 at 6:55 pm
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...
December 17, 2009 at 6:48 pm
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
December 17, 2009 at 6:38 pm
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...
May 8, 2009 at 2:11 pm
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...
May 8, 2009 at 1:56 pm
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...
May 8, 2009 at 6:52 am
Shri
I sent you a new script. Let me know if that works for you
MD
May 1, 2009 at 8:55 am
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...
August 21, 2008 at 12:22 pm
Viewing 15 posts - 1 through 15 (of 207 total)