David McKinney (11/12/2010)

---

Thanks Chris...I guess it could be analogous to a non-equi join or a cross join with a where clause, but I remain somehow unconvinced and I'd still like...

David McKinney (11/12/2010)

---

Alistair,

Just looking at it, I'd tend to agree with you. While I agree with the assertion that the CTE approach can't benefit from indexes (there are none),...

Use ROW_NUMBER() like this:

SELECT

Price,

Vendor,

Item,

rn = ROW_NUMBER() OVER(PARTITION BY Item ORDER BY Price, Vendor)

FROM...

Glyn, what version of SQL Server are you using?

Msg 121, Level 15,...

jeff.henrique.tatsoft (11/12/2010)

---

sorry

In the first post I put a simplified example

This table described in XML is First table

The second table is like the first post. I found some difficult ...

It looks a little different to your first post: "The First table is loaded by external software, and i need that after each incert in first table load second table...

Hi Jeff

If possible, can you post a few examples of how the incoming data will look?

Cheers

ChrisM

SET DATEFORMAT DMY

DROP TABLE #First

CREATE TABLE #First (Id INT, [DateTime] DATETIME, TAGA INT, TagA_Qualyty INT, TAGB INT, TagB_Qualyty INT)

INSERT INTO #First (Id, [DateTime], TAGA, TagA_Qualyty, TAGB, TagB_Qualyty)

SELECT 1, '25/11/2010', 6,...

11:11pm? Good Lord Rich, couldn't sleep? 😛

Go for it...

WayneS (11/11/2010)

---

Chris Morris-439714 (11/11/2010)

---

I had the same thought a couple of weeks ago, but a quick look revealed he'd been quite active, though...

jcrawf02 (11/11/2010)

---

Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy spool and thy...

Your sample data doesn't match your expected output, Karthik.

DROP table #balance_due

create table #balance_due

(

[name] varchar(15),

balance_due_as_on datetime,

Amount float

)

insert into #balance_due

select 'John','11/01/2010',100.25 union all --

select 'John','11/02/2010',100.25 union all --

select 'John','11/03/2010',105.00 union all

select 'John','11/05/2010',200.75...

I had the same thought a couple of weeks ago, but a quick look revealed he'd been quite active, though not on The...