Your eyes are better then mine. Yes, the last two are the same as the first. Again, it can be switched around in the middle to be different. the first...

Sorry Lynn you were right - the last two are the same.

It's okay to switch the numbers around to make them non-dupe.

The whole point is the win_id is about 14...

Actually the the values are not the same. They look the same -but they are different.

Based on my sample data - I need my output to show me a total record count for the Outcome,Staff,Disp,Month,Priority and that just for the year '2007'.

Thanks

Lynn - thanks for having patience! I appreciate that.

As you can see I am very much new to SQL - and thus far I have been used to DB's...

If you read through the thread you would see that I have posted the function and the sQL query I used in order to try and get an output. Not...

I am trying to get my report to look something like the following.

A total for each month, outcome, staff. Out of the total how many was cancelled, unknown or for...

Hi Lynn,

I wish I could provide you better data - but that's how the output looks. The relationship between the apples and grape table is the win_id. Not sure if...

Yes, I think it's fine that I match row for row since I have a Where clause that states just for the year '2007'

If that makes any sense. I guess...

I only need the Priority column from the second table. Everything else comes from the first - going back to whether I have to be specific as far as a...

I just used a Left Outer Join. For example:

FROM dbo.apple LEFT OUTER JOIN dbo.grapes

ON dbo.apple.win_id = dbo.assess.win_id

With the JOIN my query runs in 1:32. Without it, it was taking forever....

Looks like my output got messed up when sending. But the Year is obviously 2007.

Lynn,

Sample data looks like the following. I think thats what makes it more complicated. It's all numeric. As for the join - I thought I was joining it by putting...

Thanks Lynn - the last article was pretty good.

Actually I didn't create a table,etc because I was used the function to create sort of a "temp table"

So I was using...