this is going to be a scheduled job that is being used for a notification service so no one will ever un it besides when it is scheduled.

Thanks I knew it was something simple and dumb i was just not thinking about. And i am dropping the table everytime after the stored procedure is run so i...

set FILETOZIP=c:\ue_english.txt

set TEMPDIR=C:\temp738

rmdir %TEMPDIR%

mkdir %TEMPDIR%

copy %FILETOZIP% %TEMPDIR%

echo Set objArgs =...

It would be hard for me to show my entire datasource.

but out of the sample below i have highlighted the one result i would want to pull back

Company ...

I have altered my code to look like the following.

select Count(*)

FROM trWOHead WITH (NOLOCK)

WHERE Priority like '%RUSH%' and (Createdate>'6/9/2009' and Createdate<'6/11/2009') and (

(SELECT(DateDiff(dd, createdate, DeliveryDT)) As days,

...

I actually think I may have gotten it. I am checking against some data now.. I will let you know either way... Thanks for all the help!

Gianluca,

I dont see how this is going to provide me with a count for each different status type within each group...

Lowell When I run the code you give me those values end up only being 1 and 0

Do i need to do something within my report to get the...

I am not sure if that will really work. I still need to display all the fields that I was originally.

I need to get the count from the status field. The count has to be by department, and also a total count

SELECT A.ItemCode AS [Container ID], Cust.company AS Account, Dept.departmentname AS Department, A.ref1 AS [Alternate ID], A.fromdate AS [From Date],

...