LTRIM() will remove leading spaces, RTRIM() will remove trailing spaces....

Your data has a tab in it, so you are getting two rows: one with a tab, and one without. SQL will often ignore trailing spaces, but tabs are...

The GROUP BY clause creates a grouping set and you can only select or order by properties of the grouping set. A grouping set has two kinds of properties...

Is there some reason that you chose to use CROSS APPLY rather than CROSS JOIN? I tend to only use CROSS APPLY if the right side is somehow dependent...

Part of the problem is that you are accessing the VehicleMaintenance table SIX times when I think you can do what you need to by replacing your sub-queries with CASE...

The tables are logically joined in the order of the ON clauses....

ROW_NUMBER() is deterministic as long as the ORDER BY clause is deterministic. This is why it's a good idea to add enough keys to the ORDER BY clause to...

Depending on your indexes, the following may be better (and also produces the full concatenated string using the XML concatenation method).

Create table #TestTable (EmailID Int, EmailAddress Varchar (100))

Insert #TestTable Values...

Also, you can't just assume that the function is not the problem. Unless it's a inline table-valued function, it quite possibly is the problem and re-writing it to be...

You have several issues here.

1) This requires an order and your data has no obvious way to specify that order.

2) You are combining columns with different data types into a...

Luis Cazares (4/14/2016)

---

drew.allen (4/14/2016)

---

You need to be VERY CAREFUL with the quirky update. It is undocumented, not guaranteed, and requires a clustered index on the sort order. If...

Jeffery Williams (4/14/2016)

---

Yes INSERT INTO.

I am getting an error that I need an output clause. Sorry, not sure where to put that or what syntax.

Exact Error:

Msg 10716, Level 15, State...

You need to be VERY CAREFUL with the quirky update. It is undocumented, not guaranteed, and requires a clustered index on the sort order. If you DO have...

Tables represent sets, which are inherently unordered. All of the rows that contain NULL values are indistinguishable from each other based solely on the data that you have provided,...

It's probably going to be much easier to work from the raw data rather than pre-processed data. Can you post samples from the original table and the original query?

Drew