This will give you a comma separated list of company names for each user id/group id combination

SELECT

[User ID],[group id]

,VenNum_B =...

You are right, there are built in functions. I can't imagine why you would not use them, but the only sensible alternative is to use the Cryptography namespace in...

The best way to do a history of changes IMO is a seperate table that identifies all changes, inserts, updates, and deletes, and stores old and new data. It...

Please don't title your post 'help'. We know you need help, that's what the forum is for. Tell us WHAT you need help with, to attract the attention...

Hear where, on what basis ?

http://www.mssqltips.com/sqlservertip/1604/move-all-sql-server-system-databases-at-one-time/ was the best looking of the first page of google hits I got from typing in your question. A quick...

Exactly - that's why the OP needs to get business rules from the paying client, because this system will NEVER be reliable, and the most he can hope for, is...

OK, here is a recursive solution that gives a list of flights, in order, with a sequence of numbers next to them. It's assumed any stopover greater than a...

I agree. The hard part is working out where the tree stops, and where the return journey begins. That's really what I was trying to do with it,...

If there is a flight table, then this database is significantly not normalized, but he's told me in the past that they don't store the arrival dates at all, just...

I've spent an hour playing with this. This would work, if there was a maximum of one connection:

select t1.[pax id], t1.board, case when t2.[off] is null then '' else...

You modified the original post ? Reading it, you're asking for an 'arrival date' column. But I don't see any data you can use to work that out, that's...

In the first instance, the question has to be, why would you have this data in your DB ? You should be seperating this data out, in your business layer,...

I feel sorry that I opened this can of worms, I'm not sure how much benefit there is in discussing it further. My very first post there, was with...

Jeff Moden (12/30/2013)

Actually, I would have done the same thing if I thought the...

Funny enough, I got a notification that told me where the other thread was. For anyone interested in seeing the other solutions offered, it's here:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/de788fa8-2767-47bc-a29e-f50e5245e955/how-yo-make-these-two-queires-to-one-please?forum=transactsql