[Solved] Select Top

Question

5.00/5 (1 vote)

See more:

Hi All,

I have a gridview that displays data about users and their mobile numbers. It can have 100 records in it, and I have a text box that takes mobile count. By that mobile count, I will display the grid according to its size.
Example: I have 100 records and I want to see 10 only then I will write 10 in the text box and the grid will display top 10 only.

I tried to make that:

create proc test
(@mobilecount bigint)
as
begin
select top @mobilecount from tbl_mobiles

Any help?
Thanks

UPDATE:
Solved by OP herself.

Posted 19-Jan-11 19:56pm

moon2011

Updated 19-Jan-11 20:36pm

Sandeep Mewara

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hiren solanki · Answer 1 · 2011-01-19T20:01:00

Solution 1

Use Exec()[^] to achieve dynamic execution.

SQL

create proc test
(@mobilecount bigint)
as
begin
Declare @SQL varchar(max)
SET @SQL = 'select top '+@mobilecount+' from tbl_mobiles'
EXEC(@SQL)

Posted 19-Jan-11 20:01pm

Hiren solanki

Comments

Hiren solanki 20-Jan-11 2:04am

Wel come my downvoter friend come and downvote it using different account too.

Sandeep Mewara 20-Jan-11 2:35am

Looks like you know your admirer pretty well! :)
How did you pissed him/her of so much?

Rajesh Anuhya 20-Jan-11 2:53am

Can you know who is down voting??? (mentor). My answers are also down voting..

Sandeep Mewara 20-Jan-11 3:18am

No yaar, no idea.

Hiren solanki 20-Jan-11 3:21am

We can't know about who's downvoting. it's top secret for all of us.

Hiren solanki 20-Jan-11 3:27am

I haven't pissed anyone still but I don't know who's it.
He's downvoting every answer of mine.

Hope he/she will get tire from this soon.

Sandeep Mewara 20-Jan-11 3:32am

Sure the person would be tired. Just don't react.

Rajesh Anuhya 20-Jan-11 2:57am

good one take +5

moon2011 · Answer 2 · 2011-01-19T20:08:00

Solution 3

alter proc test
(
@mobilecount bigint
)
as
begin
declare @n int
set @n=@mobilecount
select top (@n) mobile,ownerName  from 
tbl_mobiles
end

Posted 19-Jan-11 20:08pm

moon2011

Updated 19-Jan-11 20:12pm

v2

Comments

Hiren solanki 20-Jan-11 2:16am

Sorry But I didn't aware about variable inside top works. It's all correct

Sandeep Mewara 20-Jan-11 2:34am

Why do you think it won't work? It surely will.

Have you executed it and seen?

Hiren solanki 20-Jan-11 3:24am

Oh my bad!! I understood the query little differently and I don't have an idea of varible executing works in normal query too in TOP.

Sandeep Mewara 20-Jan-11 3:33am

Well, this is one of the advantages here... we get to learn new things! :)

Hiren solanki 20-Jan-11 3:34am

That's why I am not leaving CP after getting this much down vote :laugh:

Sandeep Mewara 20-Jan-11 2:34am

+5 As, the implementation surely does work.

Rajesh Anuhya 20-Jan-11 2:56am

Good call., you can use @mobilecount variable directly.., no need to declare a extra variable.
take my +5