I suspect that this will perform much better than having a second CTE and a join.

WITH Combined AS (

SELECT Timestampcol, <other columns>, 'Table1' AS TableName

FROM Table1

UNION ALL

SELECT Timestampcol, <other columns>,...

Try the following.

WITH orders AS (

SELECT o.OrdID, o.OrdDt, o.CustID, o.MtchID, p.Price, p.OrdLoc, ROW_NUMBER() OVER(PARTITION BY o.OrdID ORDER BY p.OrdLoc) AS rn, MAX(p.OrdLoc) OVER(PARTITION BY o.OrdID) AS MaxLoc

FROM #Ord o

INNER JOIN...

You're going to need to be a lot more specific. I suggest you start by reading Forum Etiquette: How to post data/code on a forum to get the best...

jez.omahony (2/2/2016)

---

My problem is that in the source system, time is entered in terms of .3 is 30 mins and .15 as 15 mins... but amazingly enough .12 is actually...

Change your criteria to MEETING_TYPE IN ('PADA', 'TSM'), then GROUP BY your parent info, HAVING COUNT(DISTINCT MEETING_TYPE) = 2

Drew

There are two basic approaches you can use:

1) Use XMLNAMESPACES

2) Use a wild card for the namespace.

Drew

Here is another solution that uses new functionality specifically for paging that was introduced in SQL 2012.

DECLARE @pg_num INT = 1,

@pg_size INT = 100

SELECT [USERLOGIN]

,[USERFIRSTNAME]

,[USERLASTNAME]

,[ACTIVETODATE]

,[ACTIVATED]

,[DEACTIVATED]

,[USERID]

FROM

ORDER BY USERID

OFFSET (@pg_num -...

J Livingston SQL (1/21/2016)

---

here is a start

https://msdn.microsoft.com/en-us/library/ms189461.aspx

am trying to find the source that demonstrates the efficiency of using "unbounded preceding"...I have it somewhere <grin>

will post back if I...

No, you don't. You can use a CTE to...

Surely you've been around long enough to know how to set up a CTE with...

An INNER JOIN won't...

And what do you get when you execute the following code

SELECT ZipCode

FROM Postal_Codes_Import

WHERE...

I'm...

You...

ROW_NUMBER() is overused. Here the OP needs a single value from one record to be available across the entire partition, namely whether a NULL exists on any record in...