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
 Transact-SQL (2000)
 Help

Author  Topic 

sqlboss
Starting Member

2 Posts

Posted - 2006-08-13 : 23:30:19
I have to retrieve prior travel info for customer based on the contract number. The user will be presented with list of prior travel dates that are not repeatitive. When they click the date, customer's info will be presented.

A contract number can have two or more customer names associated when kids less than 2 years are travelling, so parent and kids will fall into the same contract number. Now how can i pull the prior travel info(customer name, address, from and to destination, from date and to date) such that the dates are not repeatitive on the screen.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-13 : 23:43:05
you are going to have to give us more info if you want some help.

read this http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx for specifics on what we will need to help you.




-ec
Go to Top of Page
   

- Advertisement -