Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Help with creating a query.......

Author  Topic 

crispy_noodle
Starting Member

1 Post

Posted - 2004-04-10 : 11:34:38
Hi,

I have a table containing country names and min and max rain fall for particular months.

I am trying to produce a query that will display the months when the rain fall (both minimum AND maximum) was greater in Country X than in Country Y.

I have tried a number of different combinations but nothing seems to work! Any tips or ideas would be greatly appreciated..

Thanks guys!

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-04-10 : 12:07:00
Can you post the ddl (table definition) and a sample script. We could then help you a lot easier.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -