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 |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2008-09-04 : 15:47:14
|
| If I run a query like "Select fsono from Inserted" and this query may have more than 1 record, how can I only pull the first fsono? Does Top work in 2000? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-09-04 : 16:14:44
|
| Alright, I feel like an idiot. I used the wrong syntax for it, did a google search, and got the impression that it was 2005+. SELECT TOP 1 (FSONO) FROM INSERTEDThat seems to work. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
select top 1 in SS 2000