Do I hear a big D'oh!  I don't use max very often and did not even think about it!  Thanks for your help and have a great day.

Exactly, it does work for one month.  Thanks for your reply Steve, I will try it.

Hi Wayne,

Thanks for your response....I ended up going with the simplest route, I created a table on my database which is a compilation of all of the aggregates in the...

You are wonderful!  Thank you so much, and have a great weekend!

Okay the girl is brain dead (it is Friday!)........!!!!

I need to know how in the syntax to use the column name to find "bal" in not just to find a...

I have been able to get the following but cannot figure out how to get the substring to work:

select orderid, productid, charindex('BAL',VendorModelNbr)as 'StartPos', vendormodelnbr

from orderitem

where writtendate = '01-Sep-05'

and vendorid =...

So basically, (if I understand correctly...have never used charindex before) if the column is named specorderinfo then:

select substring(charindex('BAL',specorderinfo)1,12)

Or something close to that?

Okay, maybe I'm being a bit dense, but I don't see how charindex will work.  I need to search all of the rows where the starting position may change based on the...

Sure, here is a very short sample list:

Exactly, the piece will have a qtynonsellable and a reasoncodeid when received, but then on a later transdaction date the same serial number will now have qty on hand and...

You can use an ODBC driver to connect your Excel spreadsheet to SQL Server.  In excel then you would click on Data-Get External Data - Create New Query.  Select your...

Thanks for your reply, we figured it out.

Database A (main database)

Database B (secondary database)

We were leaving out the dbo name from database B when we initially were trying to do...

I thought of that too, but need to get with our dba's to give me access to create views.  That may be my best bet though.

The problem is that I don't want the dates hardcoded.  I want to set them as parameters in Microsoft Query and cannot due to the "graphically" error message.  When this message shows up...