Aug 3, 2006 #1 victorashi IS-IT--Management Joined Jul 22, 2006 Messages 32 Location RO i want to make a query wich allows me to dinamicaly imput a table and a column , something like : select @a from @b .... maybe
i want to make a query wich allows me to dinamicaly imput a table and a column , something like : select @a from @b .... maybe
Aug 3, 2006 #2 mrdenny Programmer Joined May 27, 2002 Messages 11,595 You would need to use dynamic SQL. Denny MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com Upvote 0 Downvote
You would need to use dynamic SQL. Denny MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com