drew.allen (4/24/2012)

---

Here is how I would approach this.

WITH CTE AS (

SELECT DateValue, [Value], ROW_NUMBER() OVER( PARTITION BY DateValue, [Value] ORDER BY (SELECT 1) ) AS rn

FROM #tableOne

EXCEPT

SELECT DateValue, [Value], ROW_NUMBER()...

Nice, works good. Thanks! I learned a lot :Wow:

exactly:-D

Almost SSCrazy ,

I have tweaked your code a bit and this is the result:

--===== table one

CREATE TABLE #tableOne

( ...

You need to explain your "match" and "no match" rules!

Are the match between data in tableOne and tableTwo is by DateValue only? By DateValue and Value?

By DateValue, Value and number...

If i try your query I don't get any records?

just hypothetical representation of text

hey guys,

sorry for the delay, But here is the code 😎

--===== table one

CREATE TABLE #tableOne

( ...

Ok guys,

Thank you. It's clear. I'll try to be more specific. I am a newbie you know :blush:

By the way what does DDL stand for? what does it mean?

Tommorow I'll...

Please guys

Just help me out here with an example query or maybe it is not possible what I am asking?

Mo,:Whistling:

Hi,

thanks for your fast reply.

The thing I am trying to filter out are the first 2 rows from table one. Because the first two rows are in table two they...