SQL Server Performance

sql 2000

Discussion in 'General Developer Questions' started by shanakv, Sep 5, 2006.

  1. shanakv New Member

    hi all,

    i want to get weekly hours for a project to be calculated.

    the total number of weeks will be taken on every fridays.(monday-friday)

    if the date given falls under the present week the other weeks should be taken as forecast hours.

    how to get a query in a stored procedure.


    regards
    shan
  2. FrankKalis Moderator

    Welcome on board! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Can you please post your table structure, sample data and required output? From your description it's a little bit difficult to guess what you are trying to do.<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

Share This Page