Guest Andrew Buchan Posted September 7, 2009 Report Share Posted September 7, 2009 I have an Application which queries multiple tables in a SQL Server 2005 Database.For example I have 3 tables, for simplicity sake lets say the tables are called t1, t2 and t3And in those tables I am checking columns for a given value, lets say the columns are called c1 and c2.So, I want to return an extra column/field that states the name of the column which contains the given search value.Is this possible in a query? Link to comment Share on other sites More sharing options...
PravinBhat Posted October 12, 2009 Report Share Posted October 12, 2009 I dont think that there is a way to do so Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now