Tech
Forums
Jobs
Books
Events
Live
Learn
More
Training
Interviews
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Get top 10 records from sp
Ajay Mavatkar
Jun 20 2017 7:12 AM
277
Reply
Hi,
I have a sp and I need to get top 10 record from sp.
Here is my effort,
DECLARE @Temp TABLE(id INT,Name VARCHAR(20),Phone VARCHAR(20))
INSERT INTO @Temp
EXEC sp_MyListReport
@id, @Name , @Phone
SELECT TOP(10) * FROM @Temp
@id, @Name , @Phone are parameters for sp, but it is not showing any records.
Any help will be appreciated. Thanks in advance
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
What use of Cross apply?
append dynamic where condition inside sp