No worries. Obviously, when your client is chasing you, it's a problem to you, and if you've not been given enough info to do your job, and if you're...

Sure - I understand how that can happen. But, what do you propose should be the business rule to work out what is a connecting flight and what is...

Here's an attempt at using CTEs. It would really help to know the table structures and so on, of course.

with cte

(

select

languagetype ,

Indication,

COUNT(AcctID) as Clients,

AVG(TaxRate1) as SavingRtAvg_RT,

SUM(BeforeStats) as BeforeSecs,

CASE...

I frequent several SQL forums, I don't even recall now which one I saw it on, but I did suggest using a CTE, and gave an example, and someone else...

Just to add, I don't think anyone is going to give you the SQL to solve this, because the issues are deeper. If you need help, we'll need to...

I am somewhat troubled. You're being paid to work for an airline, but you're really lost as to how to do the job you're being paid to do ?

Everything...

I am somewhat troubled. You're being paid to work for an airline, but you're really lost as to how to do the job you're being paid to do ?

Everything...

Surely you know enough about SQL to add the first name as a field ? It also seems to me like you have issues in part because of how your...

Did you run the SQL he provided ? I did, and at first glance, he seems to have answered your question.

What question do you still have ?

I am confused. I posted some SQL that used a CTE, and someone else looked more closely than me and realised the two queries were in fact compatible to...

You also don't need to look up the identity value that was inserted, you can get it using SCOPE_IDENTITY

http://technet.microsoft.com/en-us/library/ms190315.aspx covers it.

It's really kind of rude to post the same question on many different forums, instead of just taking part in a community somewhere.

This has been answered, by me, elsewhere.