Thanks Wayne, that's an interesting solution. I am testing and will get back with results.

Lutz, I had looked at building a dynamic query string, but was thinking...

WayneS (11/9/2010)

---

Marcus,

Let me try to simply explain.

An index is on multiple columns - in your case, EmpNum...

Great Craig, I'll look into your suggested reading links.

Hi Craig, other than reading you're link:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

No I haven't seen execution plans. Looks like I have some homework to do... 🙂

Actually no I don't, my knowledge of indexes in general is limited...

Thanks WayneS, I appreciate you taking the time to explain.

Hi, I know my question was very vague. I work for a telecommunications corp on a team that supplies inhouse reporting and applicaiton solutions for a large call center....

Thanks George, that helps a lot.

Thank you...

Thanks Lynn that worked...Not sure why a double 'from' was needed, is there a better way to write something like this?

Hi Jeff, Lutz and Lynn...thanks for taking the time to reply...What I'd like to do is create a report for our process team that takes related orders identified by a...

Lynn Pettis (1/19/2010)

---

You have verbalized the desired output, could you show us what the final result of the query would look like? A picture is like a thousand words....

Thanks lmu92...I appreciate the detailed explanation. I will have to research more regarding indexing. I've heard the term before but don't really understand the concept.

What's happening with this query is that because it's a new year

the month value has reset to 1 so what i'm asking for is all data

with month part values between...

Hi rf44...by [Field1] & [Field2] & [Field3] do you mean column headings?

I'm actually looking to...