Hi Jeff,

I just got home from work so haven't had any time to mess with it. I don't know if "View" is the word I'm actually looking for. What I...

Also...

Since I was up at an ungodly hour anyway, I went ahead and added a calendar table to my DB(from a script on this site), used it to set a...

Hi Jeff,

One problem: the results on items with One-To-One relationships are spot on, but the results with One-To-Many relationships are being averaged on the total number of results rather than...

Hi again all!

Jeff: Did you teach me a Tally Table in that same post 2 years ago? Sounds familiar, I'll have to look back at that! In the mean...

Sorry Jeff!:-)

I guess I was impatient and looking for a quick push in the right direction. I've gotten most of the code together, but have to go to work right...

Hi again,

I've managed to retrieve the info for the one day for the multiple items through joins to two other tables(I will supply CREATE TOs if neccessary after my follow...

Hey gah,

I've been out of town for a few days, just got the chance to delve into your suggestions.

Looking at my data, it seems that, for the...

Thanks for your time and thought! I am at my daily grind right now, so won't be able to try your code until later.

If I understand you correctly concerning the...

I also just realized how stupid the types are for "Pack" and "Size", please ignore and use proper types (Int, I suppose) for fields.

Mike

Hi,

Here is create statement. The vendor's tables are all same, so just create two with different names:

CREATE TABLE [dbo].[USFoods](

[Product #] [int] NOT NULL,

[Cat_ID] [smallint] NULL,

[SubCat_ID] [smallint] NULL,

[Description] [varchar](255) NULL,

[Brand] [varchar](255)...

p.s. I should have also stated that the two example entries are in seperate tables, each vendor having their own.

Mike

Hi gah,

Thanks for replying.

The specific project I'm working on will need the ability to compare two uoms and convert to the same base class for a price comparison. for example...

Hi again rbarryyoung,

Are you psychic? I was logging in to see if any replies on SQL books, while in the back of my mind the question to your answer was...

Hey rbarryyoung,

I believe that last statement hit it! I'll figure out how to fit it into my scenario.

Speaking of which, any comments/advice on the structure of the two tables you've...

P.S. All the code I've tried so far I have deleted in frustration. If you would care to see the VB code that I managed to match the datagridviews with,...