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.
| Author |
Topic |
|
senpoly
Starting Member
19 Posts |
 Posted - 2007-06-13 : 10:10:51
|
| dear friendsi have a table with 30 rows with multiple columnsin which one on columnname is empnameand it has values of "Senthil" and " mathi" each of 15 rowsi need a select command to get top7 rows from each namewith out using cursorcan anybody help me in this regardsenthil kumar |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-13 : 10:20:00
|
| http://weblogs.sqlteam.com/mladenp/archive/2005/08/01/7421.aspxpoint 2_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
alternate to cursor