| Author |
Topic |
|
taunt
Posting Yak Master
128 Posts |
 Posted - 2011-10-04 : 18:25:04
|
| Hello I'm trying to do a select query in MSSMS 2005 and I need it to select rows 10-20. Any info would be great. Need it to select rows 10-20 from upc in items.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 00:55:23
|
| you need totally 10-20 rows or 10-20 rows for each upc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
taunt
Posting Yak Master
128 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
taunt
Posting Yak Master
128 Posts |
Posted - 2011-10-05 : 12:08:44
|
quote:
Originally posted by tkizer
ROW_NUMBER() works fine on all service packs. We are on SP3 on some systems and SP4 on other systems, it works fine on each of them.Maybe you are returning too much data? Show us the code.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
SELECT upc, ROW_NUMBER() OVER (ORDER BY upc DESC) AS RowNumberFROM itemswhere sku like 'zzz[0-9]%'When I do that with SSMS it will freeze then after 30 seconds say an error occurred SSMS has to shut down. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
taunt
Posting Yak Master
128 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
Sql query select rows 10-20