hmm , yes i found out that some names are without / , what should be the best practice here ?

Thank you , whenever i used the -1 , i get error message

HI , thanks for your quick response , incase i am having the value 'Mr' as part of the value how its going to handle it like in the sample...

Hello all,

thank you for your comments and valuable advises , unfortunately i wasn't the one who build this structure ,i am getting those data in row format exported to...

Thank you my friend , i need to add small where condation to show bookings that has flight date greater than today and the leg status = 'c' ,...

Dear Friends ,

I was not able to adjust the query you send with my actual table , so may you please assist with the current tables structure:

CREATE TABLE...

you are really experts.. 😀

Hi friends ,

I run the script mentioned and finally i got one of the tables giving the results and i have run the same script on other table that has...

Dear friend

Thank you for your quick response, i tried that , but two points still need your assistant with is those two tables are from two different databases ,...

Hi Friends , I would like to thank you all for whom they tried to help in that query it was really challange. but for sure each problem has solution....

If the arrival date is an issue , I can tell my client to escape it but at least the transit cities should be correct .. the new query gives...

Hi friends thanks for your input and comments and imagine thats the case.. actually the host system who provides the service gives this limited data export to the client and...

1- create query

CREATE TABLE table1(

[Pax ID] [int] NULL,

[Reservation] [int] NULL,

[Surname] [varchar](40) NULL,

[First Name] [varchar](40) NULL,

[Pax Type] [char](1) NULL,

[Flight Date] [smalldatetime] NULL,

[Flight Number] [varchar](10) NULL,

[Board] [varchar](3) NULL,

[Off] [varchar](3) NULL,

[Original Booking Date]...

Dear Christian , i have edited my query and the data i posted earlier hope the query more clear now please let me know if still you have any...

Thanks , let me do some home work and try to find out how i can make the business rule with the client. and let you know shortly. thank you...