Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-23 : 07:11:35
|
| Trevor writes "I have Tables AUG03 SEP03 OCT03 the structure of the tables AUG03 Field1 Field2 Field3 1 Dove Red the structure of the tables SEP03 F1 F2 F3 1 Dove Red the structure of the tables SEP03 RecNo Desc Color 1 Dove Red I want a function that works like this select * from dbo.GetTableValue('AUG03') the parameter will be the tablename and returns all records from the table it display like this Field1 Field2 Field3 1 Dove Red select * from dbo.GetTableValue('SEP03') F1 F2 F3 1 Dove Red select * from dbo.GetTableValue('OCT03') RecNo Desc Color 1 Dove RedIf you notice different Field name appears" |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-01-23 : 07:54:22
|
| Your request is explained well. But your desired technique comes into question. Can you elaborate on why you need differing columns identifying similar data? |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-23 : 09:04:14
|
| I'd like to see the function if you are able to post it. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-01-23 : 11:27:38
|
| there's a function called "SELECT" that you can use to get data from any table that you like !- Jeff |
|
|
|
|
|
|
Dynamic Function