Post reply

Stored procedure to archive data in a table into csv file

  • March 13, 2012 at 9:27 am

    #1458578

    Silly Me!!!

    DECLARE @FileName varchar(50), is the culprit..

    I increased the size @FileName varchar(250), and it's resolved!

  • March 13, 2012 at 9:29 am

    #1458579

    Annee (3/13/2012)

    Silly Me!!!

    DECLARE @FileName varchar(50), is the culprit..

    I increased the size @FileName varchar(250), and it's resolved!

    hehe 😀

    _________________________________
    seth delconte
    http://sqlkeys.com

  • March 13, 2012 at 12:15 pm

    #1458738

    Your change to use DATEDIFF function will make your qury miss the index on adddatetime.

  • March 13, 2012 at 12:27 pm

    #1458748

    You may want to change your where caluse to this:

    ...

    where adddatetime >= dateadd(dd, datediff(dd, 0, getdate()), 0) and adddatetime < dateadd(dd, datediff(dd, 0, getdate()) + 1 , 0)

  • March 14, 2012 at 11:12 am

    #1459377

    thanks for that input!

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply