Forum Replies Created

Viewing 15 posts - 1 through 15 (of 207 total)

  • RE: Date Format in SSRS

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

  • RE: Backup SQL Server Database with Move/Copy File

    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...

  • RE: TSQL Help

    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.

  • RE: TSQL Help

    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 🙂

  • RE: TSQL Help

    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...

  • RE: TSQL Help

    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.

  • RE: Import data from FLat file to sql server table

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

  • RE: SQL Server 2005 DB stuck in 'restoring'

    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...

  • RE: Unable to backup to a network drive

    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...

  • RE: Backup SQL Server Database with Move/Copy File

    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

  • RE: Stupid full Backup error

    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...

  • RE: Stupid full Backup error

    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...

  • RE: Stupid full Backup error

    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...

  • RE: Backup SQL Server Database with Move/Copy File

    Shri

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

    MD

  • RE: Storing SSIS packages...

    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...

Viewing 15 posts - 1 through 15 (of 207 total)