tag:blogger.com,1999:blog-495177919198719500.post3472429050870012623..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Passing parameter to the TOP clauseSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-495177919198719500.post-49281291512757109332011-01-14T21:03:21.041-08:002011-01-14T21:03:21.041-08:00For SQL SERVER 2000, there is workaround and pleas...For SQL SERVER 2000, there is workaround and please take a look at it here.<br />http://praveenbattula.blogspot.com/2011/01/using-variables-in-top-clause-in-t-sql.htmlPraveenhttp://praveenbattula.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-13895497307504808422011-01-07T02:17:09.436-08:002011-01-07T02:17:09.436-08:00It's indeed a clean and easy solution, but the...It's indeed a clean and easy solution, but there is a catch: it works really slow and for larger tables you'll notice significant performance-loss!<br /><br />My 2 centsChristophe Vanderhaeghennoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-69083461395307484972009-03-12T21:05:00.000-07:002009-03-12T21:05:00.000-07:00I am attempting to use this in VS2005 writing a Re...I am attempting to use this in VS2005 writing a Reporting Services report. <BR/><BR/>However, I am receiving the error "The number of rows in a TOP clause must be an integer". <BR/><BR/>The parameter within the report is set as an integer. It seems VS is sending the parameter value as something other than an integer?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-80077325805312374892008-10-22T09:44:00.000-07:002008-10-22T09:44:00.000-07:00I do not think that should be any problem. Are you...I do not think that should be any problem. Are you facing one?Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-26934967337993191322008-10-21T04:27:00.000-07:002008-10-21T04:27:00.000-07:00Have you had any luck using this in a VS2005 repor...Have you had any luck using this in a VS2005 report?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-8517999840122641872008-08-20T09:03:00.000-07:002008-08-20T09:03:00.000-07:00it is very good.It solve my problem.it is very good.It solve my problem.Anonymousnoreply@blogger.com