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