Retrive temp table depends on vlaue from other table

Question

0.00/5 (No votes)

See more:

Hi all,
IN SQL Server, ( and ASP.NET )

i need to create stored procedure ,
first : select numberOfMonths (int value) from table1
second: return temp table contains number of rows equal to value numberOfMonths
this temp table consist from just on column (int type) each row have one value
row 1 have : 1
row 2 have : 2
......
row n have : n , n is the returned value

But I don't want to create new table in database

How can I do that ? plz help me

Posted 2-Oct-13 22:56pm

ocean99

Add a Solution

Comments

Tejas Vaishnav 3-Oct-13 5:05am

can you provide your desired out put of store procedure?

ocean99 3-Oct-13 5:05am

notice : n = numberOfMonths

Tejas Vaishnav 3-Oct-13 5:06am

means? you need to get number of month from your table..

like

1
2
3
4

ocean99 3-Oct-13 5:08am

yes that is right

Tejas Vaishnav 3-Oct-13 5:10am

i think there is a 12 month in your table and you need to pass a value to your storeprocedure like 5 then it will return 1,2,3,4,5 am i right?

ocean99 3-Oct-13 5:12am

yes , you right

1 solution

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)

Tejas Vaishnav · Accepted Answer · 2013-10-02T23:20:00

SQL

DECLARE @tablofmonth AS TABLE (MONINDEX int)
INSERT INTO @tablofmonth VALUES(1)
INSERT INTO @tablofmonth VALUES(2)
INSERT INTO @tablofmonth VALUES(3)
INSERT INTO @tablofmonth VALUES(4)
INSERT INTO @tablofmonth VALUES(5)
INSERT INTO @tablofmonth VALUES(6)
INSERT INTO @tablofmonth VALUES(7)
INSERT INTO @tablofmonth VALUES(8)
INSERT INTO @tablofmonth VALUES(9)
INSERT INTO @tablofmonth VALUES(10)
INSERT INTO @tablofmonth VALUES(11)
INSERT INTO @tablofmonth VALUES(12)

DECLARE @NumOfMonth INT = 6
SELECT TOP(@NumOfMonth)* FROM @tablofmonth ORDER BY MONINDEX


--for example
CREATE PROCEDURE SELECT_MONTH(
    @NumOfMonth INT
)
AS
BEGIN
    SELECT TOP(@NumOfMonth)* FROM yourtable
END
GO

in the above query i have used temporary table from which i have select a number.
you just need to fire a simple select query in your store procedure as demonstrating in example
you need to replace your table name in your table name place. above sql part is just for demonstration how query works