I got it, I missed out OUTPUT when declare @workdays as INT. Thanks

ahhh.... error....."has too many arguments specified"

Declare @StartDate datetime, @EndDate datetime, @WorkDays INT

Select @StartDate = '12/17/2007', @EndDate = '12/25/2007'

Exec dbo.PIN_WorkDays @StartDate, @EndDate, @WorkDays OUTPUT

using exactly what previously corrected (except for 'worddays'...spelling??)

SET...

thanks Jeff,

I am still learning and this is just to see how it works. Sure if I use the code anywhere, your name will be there.

I am not so familiar...

The only thing I changed was to make it as SP instead of a function. Thanks

---Declare @startdate datetime, @enddate datetime

---Select @startdate = '12/17/2007', @enddate = '12/25/2007'

Exec dbo.TEST_WorkDays '12/17/2007', '12/25/2007'

SET...

How do I post CF code here??

Hi,

Jeff I try to understand your code and learn how to work with SP and all. Here is what I tried to run the example that you wrote here (finding...

sorry folks,

I am a newbie here and I wonder if some one is kind enough and explain to me how do I get the number of days out of this...

never mind , I found the prob. There was a trigger that references an old sp which no longer existed.

Thanks Terry, I will give it a try.