hi

source tabl
state yr2002 yr200
-----------------------
Andhra 1000 150
Karnataka 2000 180
Tnadu 3000 100
Kerala 2000 300

I want destination table thi

State year noofcontract
---------------------------
Andhra 2002 100
Andhra 2003 180

How can i transform it through activex scripting ? pls help me

thanks in advanc

ns rao

---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/

Why not simple T-SQL as the source in a data transformation query

Select distinct State, 2002 as [Year], yr2002 as noofcontact
from [source table
union
select distinct State, 2003 yr2003
from [source table

hi

thanks for reply .. i can't use union because my source table contains nearly 1million records.. (this i gave just as example) ..so if i use union clause it results in full table scan of twise which will considerably take much time..

is there any other solution

Thanks in advanc

ns rao

---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/