You are welcome. BTW the query I used was Remi's I just created some tables that would match. I had come to the same conclusions but type much much slower...

Thanks for your kind offer. However, being un-civilized savages who enjoy both baseball and football we must refuse.

Lots of assumptions (read as guesses) here as you did not post your DDLs Basede on the information you posted I guessed that your tables look something more or less like...

From the original post we do not know if the database has been rationalized. IF you would like to read Dr. Codd's rules for normalizing a db please check this...

Sukhoi I just noticed two things about the referensed post. First You had not tried Remi's solution which based on the information you posted should have worked. But with out DDLs...

Sukhoi we were not making fun of your question just having a little fun. If you would please post your DDLs some sample data and expected results we would be...

Scott try posting your questions on this XP site http://www.microsoft.com/windowsxp/expertzone/newsgroups/reader.mspx?dg=microsoft.public.windowsxp.basics

As to the tech support you recieved from your vendor he should go back to his comic book reading. While...

Joe would you please post the DDL for your tables

Thanks

Mike

p.s. checking out this site is recommended (by me )

NO laptop  you will go into major withdrawal. your fingers will tremble and type meanless words on the table. You will be caught on...

to cover every area, the test would last for days, and the certification would require years of training….. but education cannot keep up with the ever changing world. The MCDBA...

If you will be using this information often I would create a table fo EMA and store the data in that table not a temp table.

/*

to calculate an exponential moving...

Certification programs maybe a better indicator than experience during...

{quote}You'd think that if Oracle, DB/2, or someone else hired away someone from the SQL Server team we'd hear about it. It would be an interesting coup.

I am sure...

 7/2/25 Thanks Steve, sitting here in my usual state of mental alertness I read your post and panicked as my daughter is flying in on the 2nd and I have to...

"ps:As for no gender having monopoly on any particular behaviour or attribute - I completely (but respectfully) disagree.....don't get me...