When you refer to Books On Line, is that something on this forum? I apologize ahead of time if this is a stupid question...

Lynn Pettis (6/29/2009)

---

ddicecca (6/29/2009)

---

Seriously...? That's your help? I have Googled this for a good hour already....

Seriously...? That's your help? I have Googled this for a good hour already. Hence why...

It works now. I had to convert, as GSquared pointed out. Here is what I did:

select -- convert(varchar, delivery_date, 101) as DeliveryDate,

...

Gsquared,

Could you give me an example please?

Thank you very much. I will try that after I figure out my percentage problem. :w00t:

slange (4/22/2009)

---

Just judging by the format of the code I will try this.

where delivery_date between @StartDate and @EndDate and

...

slange (4/22/2009)

---

The problem lies in the where clause...

where delivery_date between @StartDate and @EndDate and

driver = e.emp_cd and

...

These return first, before the BETWEEN dates:

01/02/2008C003CAOakwoodATKGCH13110455Total4GERALD HOOD

01/03/2008C003CAOakwoodATKGCH11000490Total0GERALD HOOD

01/03/2008C103CBOakwoodATKGCH11000281Total0GERALD HOOD

01/04/2008C003CAOakwoodATKGCH11010381Total1GERALD HOOD

01/04/2008C103CBOakwoodATKGCH11110293Total1GERALD HOOD

01/05/2008C003CAOakwoodATKGCH12000402Total1GERALD HOOD

01/05/2008C103CBOakwoodATKGCH7000502Total1GERALD HOOD

01/09/2008C003CAOakwoodATKGCH13010421Total2GERALD HOOD

01/09/2008C103CBOakwoodATKGCH7000230Total0GERALD HOOD

01/10/2008C003CAOakwoodATKGCH8100160Total0GERALD HOOD

01/10/2008C103CBOakwoodATKGCH12010331Total2GERALD HOOD

01/11/2008C003CAOakwoodATKGCH12110450Total0GERALD HOOD

01/11/2008C103CBOakwoodATKGCH12200192Total0GERALD HOOD

01/12/2008C003CAOakwoodATKGCH7000282Total2GERALD HOOD

01/12/2008C103CBOakwoodATKGCH15210384Total3GERALD HOOD

01/15/2008C003CAOakwoodATKGCH12020310Total0GERALD HOOD

01/15/2008C103CBOakwoodATKGCH4000210Total0GERALD HOOD

01/16/2008C003CAOakwoodATKGCH9010551Total0GERALD HOOD

01/16/2008C103CBOakwoodATKGCH9100212Total1GERALD HOOD

01/17/2008C003CAOakwoodATKGCH8010320Total0GERALD HOOD

01/17/2008C103CBOakwoodATKGCH5000253Total1GERALD HOOD

01/18/2008C003CAOakwoodATKGCH8010400Total0GERALD HOOD

01/18/2008C103CBOakwoodATKGCH12002583Total0GERALD HOOD

01/22/2008C003CAOakwoodATKGCH10110230Total0GERALD...

In any case, Lowell, I am getting values back with dates from 2008, which obviously, given my static start and end dates, is wrong. I'm not sure why.

If I...

Lowell (4/22/2009)

---

the between looks fine, but the rest of your WHERE statement has me puzzled:

where delivery_date BETWEEN '04/15/2009' and '04/22/2009'

and driver = e.emp_cd

and (driver = 'ATK' or '%'...