Want to retrive TOP 20 records

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

Want to retrive TOP 20 records

Author

Topic

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2014-03-11 : 05:36:10

removing this post

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2014-03-11 : 07:16:11

how about applying top 20 with in the OpenQuery? e.g.

FROM OpenQuery(Linked_AS,
'SELECT Top 20 Flattened ..... ')

Cheers
MIK

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources