select

datediff("d", openDate, closedDate) - tbl1.daysToComplete as DayDifference

from tblSale

inner join tbl1 on tblSales.task = tbl1.Task

where task like '%New%'

and tblSale.qtr = 3

and tbl1.Year = 2010

and closedDate NOT in...

ok so i now have my date table with all of the date from 1/31/2005 to 12/31/2015, so now, how can I determine if a date between 4/1/2010 and 4/15/2010...

how would I do a "calendar" table?

I think i just fixed it, i changed the order of my where clause and it appears to be working now.

LOL,

No, I'm using 2005, I tried it in 08 to see if was an SQL version issue, but my 08 crashed. (good times)

I got an error on that was well referring to "N"

Thanks for the input, its greatly appreciated. However, I'm trying some of the suggested queries and it keeps kicking me out an error:

SELECT TOP (1)

...

nope no homework, no interview questions, its an actualy business requirement for this application that was once an access app and everything was done manually, now i'm automating it and...

yes, I can upload the file just fine, i want to add the upload date to the table which is failing

I tried that and it errors and the data is never uploaded to the table

i just need a final count, so if i run my query (as above) and I get 100 records and 48 records are below 0, I need to count them....

yes

I love coding against a moving target. 🙂

Now, I just got asked to count all items (var) that is a negative number,

so if var is -5, -6, -20, etc,...

that's what i did actually and it worked.

thanks

not sure if this the best way but i did this.

(RequiredCompletionDays - DATEDIFF(dd, COALESCE(tbl1.Opendate,tbl?.YourOtherDateColumn) , tbl1.ClosedDate)) as variance

and it returned my correct number.