You might check out stuff from Scott Cate here:

http://scottcate.mykb.com/

Hey Remi,

Is there such a thing as a "Piviot Table View" and might it work in this case until she can normalize the tables?

I agree with John, any edit to the "Product Definition" can not be made if there are Order Items dependant on the Product Key in the Sales History or Orders tables.

Orders, simular to invoicing, should and can be set for change right up until shipped, billed or posted. 

In our systems, the Order is the historic event and has a status...

You might try a union statement:

SELECT Shop_name, ‘milk_bread_butter’ as Product, sum(sales_amount) as sales

FROM Dbo.sales  Where prod in (1,2,3) GROUP BY  shop_name

I don't quite understand.  Do you mean build a lookup table with all the possible valid combinations and use this for the source table instead of the International table?  International City_codes...

Serqiy,

Holy smokes! You came pretty close on the first shot.

I am astounded at how simple set solutions can be.  The other is certianly a mess.

Perhaps I should clarify.  When...

They tell me taking Ginko Baloba helps with the memory problems.  I keep forgetting to take mine!

I agree with you Steve.  The team is more important than the degree or the level of best. 

I would have to believe that the most important attribute for any...

Hey Jeff, thanks for the reply and terrific solution. 

I have created the tally table and the functions. Either works well. 

And, it does run fast!!! 

Great explaination Vladan.  Made me wonder if I should revisit some of my old joins to see if I did them correctly! 

Thanks.

This is the function I created.  Is there a better way to do this?

CREATE FUNCTION GetDayofWeekCount (@startdate datetime, @EndDate datetime, @DayofWeek int)

RETURNS Int AS

BEGIN

Declare @days int

Set @days =...

You might try something like this from your original Query in lieu of the subquery to sort by:

SELECT Case when DATEPART(dd,dtDate) < 10 then '0' + CONVERT(VARCHAR(1),DATEPART(dd,

September 28, 2006 at 10:15 am