Got it. Thanks

Eralper (6/21/2010)

---

Hi pcgm,

My code responds to changes in model

If you want to respond to changes in value column please change the WHERE clause as follows

t1.value <> t2.value --t1.model...

Thanks. Got it. Basically add a column rownumber as identity.

bteraberry (6/21/2010)

---

declare @t_temp table (ID int, Value INT, Value2 VARCHAR(20))

insert into @t_temp

select 1, 5, 'Win32' union

select 2, 5, 'Win32' union

select 3,...

Hi, Erapler

I used your solution, but did not get what I really want, did I miss anything? Thanks

DECLARE @t TABLE(ID INT,Value INT,Model VARCHAR(50))

INSERT INTO @t

SELECT 1, 5, 'win32' UNION ALL

SELECT...

Thanks Steve.

This is what I got from abdshall@Technet, and it works:

DECLARE @t TABLE(ID INT,Value INT,Model VARCHAR(50))

INSERT INTO @t

SELECT 1, 5, 'win32' UNION ALL

SELECT 2, 5, 'win32' UNION ALL

SELECT 3,...

Thanks Steve... This is exactly what I am thinking now. Let's say there's another column in the table

ID Value...

Thanks!!! This is it.

bteraberry (6/18/2010)

---

declare @t_temp table (ID int, Value int)

insert into @t_temp

select 1, 5 union

select 2, 5 union

select 3, 7 union

select 4, 7 union

select 5, 7 union

select 6, 7...

Thanks. It doesn't work though. The ID column is an identity column...

Samuel Vella (5/19/2009)

---

Are you querying a Cube or a...