Wow thanks Luis!!

I like both, but will probably use the FOR XML option!

-James

Thanks!

Here you go...

CREATE TABLE DBA.Items(

strBBranchCode_FD CHAR(2) NOT NULL DEFAULT '',

lFFoldNo_FD INT NOT NULL DEFAULT -1,

nFiFoldItemID_FD SMALLINT NOT NULL DEFAULT -1,

strFiPaxName_FD CHAR(100) NOT NULL,

strFiTktNo_FD CHAR(100) NOT NULL,

strFiBookingRef_FD CHAR(100) NOT NULL,

PRIMARY KEY...

Thanks guys...

My select * was just an example. I was actually selecting using a coalesce - COALESCE( C.ClassName_FD, C2.ClassName_FD, '' ) etc. Basically getting the class from the...

Ah yes Luis... That worked a treat!

Thank you - much appreciated!

James

Thanks MM, a nice alternative. I have learned a lot about STUFF and FOR XML this week thanks to you guys!

Wow... I am blown away by the support I receive from you guys! You are one smart cookie Lowell! Thanks for enlightening me on this cold evening 😀

Sorry... as you can see I am no expert!

I believe the the use of no lock is due to the usage of the function that is being called in a...

Apologies everyone...

Basically I have a table that contains the names that relate to the bookings in the database. I booking can consist of a single passenger or multiple passengers....

Sorry, I didn't make myself very clear did I...

The passenger list will vary every time in both the names and number of passengers, so I need to somehow find the...

Thanks, I get the bigger picture now, but what is the "values" part doing? Why the 6 "(1)" records and the significance of the a(x) and b(x)? Sorry for being...

Wow that is brilliant thanks MM!

I have never used the APPLY operator before, but it works perfectly. I would love to say that it all makes perfect sense to...