aown


i m facing a prob in sql.
the problem is that i m having a table say 'A' which contains the names of the columns of a table say 'B' now
i want to make a select so that the we can select the columns of
'B' table depending on the data of 'A' table....how can i implement this..




Re: sql problem

aown


i know there is some dynamic queries involved in this but i need an exact query






Re: sql problem

Arnie Rowland

Just in case no one mentions it, "That is a 'sucky' design!"







Re: sql problem

aown

This is not a sucky design.......i have simplified my code so that dumbs can understand....the basic scenario was that i was passed a string which had the column names in it and i parsed it and saved it to a dummy table so that i can further use it......thats the whole scenario anyways if u dont know the answer it doesnt means that the design sucks....mind it





Re: sql problem

rusag2

How are the names stored in table "A" Is it one record per column name, or are they all in a single field