Something like this will return the number of weeks and remaining days + remaining work days.

CREATE FUNCTION [dbo].udfGetWeeksAndDays

(

@StartDate DATETIME

,@EndDate DATETIME

)

RETURNS

TABLE

AS

RETURN

(

with...

Should look into using n-hibernate tool such as CSLA, LLBLGen Pro, etc... The CRUD procedures should reside in the DataAccessLayer.dll.

Good article RBarry Young. I got rid of my cursor by

- Store the result data in table var with rownumber

- create a row index var to loop...