I need help in to retrieve data repeated

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

I need help in to retrieve data repeated

Author

Topic

Harhour
Starting Member

3 Posts

Posted - 2010-10-28 : 06:24:22

Hi I have this table of 9 columns
and 8 rows where IDWk is not duplicate

Qty_wk1 Qty_wk2 Qty_wk3 Qty_wk4 Qty_wk5 Qty_wk6 Qty_wk7 Qty_wk8 IDWk
1 1 2 33 48 510 60 70 80 2275
2 1 2 33 48 510 60 70 80 2276
3 1 2 33 48 510 60 70 80 2277
4 1 2 33 48 510 60 70 80 2278
5 1 2 33 48 510 60 70 80 2279
6 1 2 33 48 510 60 70 80 2280
7 1 2 33 48 510 60 70 80 2281
8 1 2 33 48 510 60 70 80 2282

i want to select all rows (8 rows ) like the following
Qty_wk1=1 and IDWk of the first row = 2275
Qty_wk2=2 its IDWk =2276
Qty_wk3=3 its IDWk =2277
Qty_wk4=4 its IDWk =2278
Qty_wk5=5 its IDWk =2279
Qty_wk5=6 its IDWk =2280
Qty_wk5=7 its IDWk =2281
Qty_wk5=8 its IDWk =2282

please help
i am stuck ..

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-10-28 : 07:11:55

Try this -


SELECT 'Qty_wk' + CONVERT(VARCHAR(10), ROW_NUMBER() OVER( ORDER BY (SELECT 1)) ) + ' = ' + CONVERT(VARCHAR(10), ROW_NUMBER() OVER( ORDER BY (SELECT 1)) )
+ ' its IDWK = ' + CONVERT(VARCHAR(10), IDWK)
FROM <Your Table>

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources