Home Forums SQL Server 7,2000 T-SQL convert DateTime to BigInt RE: convert DateTime to BigInt

  • January 20, 2009 at 4:57 am

    #929608

    munishprathap (1/20/2009)

    we cant predict no. of rows affected assume tht tables have 10 rows

    How many rows do you have in the table right now?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden