Post reply

Select statment for function report takes more time

  • April 23, 2010 at 12:03 am

    #234142

    Hi All,

    If i use select query in sqlserver2005

    'SELECT * FROM UF_Report_DATE ('03/22/2010')

    This function query only takes more for current date.

    if i run for previous days it will generate in sec.

    thanks in advance

    udhaya

  • April 23, 2010 at 7:11 am

    #1156804

    That's not a standard TsQL function, so you must have written it. Without the code, it's hard to know what's happenning. If you post the code for the function, you might get more help.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

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