You're UPDATE statement is incorrect.  If you are going to alias something, you need to use that alias throughout.

UPDATE o -- use the alias here.
SET o.Description =...

A picture of your data is worthless.

1. You need to provide a script using the {;} Insert/edit code sample that does the following.

   1. Creates a temp table or declares a...

Your "header" row has five columns, but your details rows have eight.  Without knowing what your final goal is, it's hard to tell you the best way to resolve this...

This is much more efficient.  Note that it has a windowed function SUM() OVER() of an aggregate SUM().

SELECT
per
,company
,account
,COUNT(*) AS accNum
,SUM(amount) as accTotals
,SUM(SUM(amount)) OVER(PARTITION BY per, company) as...

I'm not sure that all the answers given in this thread are correct?

The where clause, if indented, looks like this:

WHERE 1 = CASE WHEN T.record_Key_4 =...

This is a variation on packing intervals.  Itzik Ben-Gan has written a number of articles that might be helpful.  If you post consumable data I can help you with it. ...

You're doing a partial CROSS JOIN.  You either need to SUM your totals before joining or do a UNION before SUMming.  You could also use GROUPING SETS.  Since you failed...

Hi

Sorry, i got caught up doing another project....

Honestly, I "sorta"  get what's going on here,

STUFF(
           ...

Show us what you've tried and we'll help you through it.  There are a couple of ways to approach it.  I would probably start by changing what nodes are returned...

I used an XML variable, but you can easily replace the variable with your field.

SELECT STUFF(
(
SELECT ',', c.value('.', 'VARCHAR(20)')
FROM @doc.nodes('/Data/Purpose_x0020_of_x0020_Request/Data_Purpose_x0020_of_x0020_Request_Option[Checked="true"]/Name') T(c)
FOR XML PATH(''), TYPE
).value('.', 'VARCHAR(255)'), 1, 1,...

The query you provided appears to be doing something like a running count of passengers on each event but it doesn't quite get it right.  I need just one...

When you provide sample data DO NOT USE A PERMANENT TABLE. You should either provide a temp table or a table variable.

When you provide sample data, the VALUES clause can...

I see nothing in your data that indicates that you picked up 9 people at the same time/location.  There is no way to provide a solution without that field.  If...

You were already given an answer to this in your previous thread.

Drew

EXCEPT is unlikely to be the best performing solution here, because it requires you to read the table twice and there are other solutions that should only require reading the...