Get Table as A variable

Question

1.00/5 (1 vote)

See more:

Hi everyone,

I have a table with name "test" and i want to get table entity itself in a variable so i can use it in join statement

Note:
i have table name in run-time and i want to get the table itself in a variable.

Thanks in Advance :)

Posted 29-Dec-12 10:05am

AhmedYehiaK

Add a Solution

Comments

Wendelius 29-Dec-12 16:12pm

Could you explain more, what are you actually trying to do? Do you mean you want to dynamically construct an SQL statement or something else?

4 solutions

Solution 4

Thanks a lot :) , this working correctly

Posted 29-Dec-12 10:25am

AhmedYehiaK

Comments

Wendelius 29-Dec-12 16:28pm

You're welcome. You can use the "Have a Question or Comment?" button to send a comment directly to a specific solution. This way the person who wrote the solution gets notified, just like with this message :)

AhmedYehiaK 29-Dec-12 16:31pm

Thanks :) the next time i will use it :)

Wendelius 29-Dec-12 16:34pm

No problem at all :)

Solution 2

Thanks firstly :)

SQL

declare @name nvarchar(50)
set @name = (select Name from Lookups where Lookups.ID = 4)

NOW [@name = MyTableName say "Items"]

then i want to do something like:

SQL

select * from @name

OR

using @name in any join statement

Thanks

Posted 29-Dec-12 10:20am

AhmedYehiaK

Solution 1

This makes no sense at all. Your question is a SQL question. You can use the table in a join statement, there's no issue there. If you have an actual issue, it's not clear at all.

Posted 29-Dec-12 10:15am

Christian Graus

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)

Wendelius · Accepted Answer · 2012-12-29T10:23:00

Solution 3

Ok, so if I understood your question correctly, then you could use dynamic sql, something like following:

SQL

declare @name nvarchar(50)
set @name = (select Name from Lookups where Lookups.ID = 4)
execute ('select * from ' + @name)

For more information, see EXECUTE[^]

Posted 29-Dec-12 10:23am

Wendelius

Updated 29-Dec-12 10:25am

v2

Comments

Espen Harlinn 30-Dec-12 8:10am

5'ed!

Wendelius 4-Jan-13 15:12pm

Thank you :D