Get column value from dynamically achieved column name

Question

Below is the code where I am getting a columns name dynamically(example F8 is the column name) and storing it in @whcode. What i need is the value that is stored in this column for the where condition specified below. I can see the value stored in the column is 2 but I cannot get it. What it is returning me is the column name itself. How can I get the value in the column. Please help.

declare @count1 int
set @count1 = (select min(srno) from TEMP_STOCK_uPDATE)
declare @whcode varchar(20)
select * from TEMP_STOCK_uPDATE where srno='16091'
set @whcode=(SELECT COLUMN_NAME
            FROM Ecata_New.INFORMATION_SCHEMA.COLUMNS
            where Table_Name = 'TEMP_STOCK_uPDATE'  
            and COLUMN_NAME =(select whcode from dbo.temp_stock_map where func=(select func from dbo.temp_stock_map where sr_no=6)))
--select @whcode as 'abcd'



select @whcode as 'abc'
from TEMP_STOCK_uPDATE
where 
F1=(select F1 from dbo.TEMP_STOCK_uPDATE where srno=@count1)

This is only going to get messier and messier as you continue down this route. As I suggested in a comment to your previous question, instead of going down (what looks like) a blind alley, maybe you could present us with the overall problem to be solved, and we might, then, be able to offer an overall solution to the problem - rather than you continue to present us with the problems with the solution that you've already decided upon. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jun 20, 2013 at 9:45
@Damien_The_Unbeliever : stackoverflow.com/questions/17211611/… . Is the link for my problem that you have asked for. Please visit the link. — Ankur
– Ankur, Commented Jun 20, 2013 at 10:44
@Damien_The_Unbeliever : I got the answer , wrote 2 while loops and was able to fine the column name and its value dynamically. — Ankur
– Ankur, Commented Jun 21, 2013 at 6:43

NigelK · Accepted Answer · 2013-06-20 11:16:22Z

1

You can build your SQL statement dynamically to do this. Build your statement in a varchar and then EXEC it.

DECLARE @SQL VARCHAR(4000)

SET @SQL = 'select ' + @whcode + ' from TEMP_STOCK_uPDATE where F1=(select F1 from dbo.TEMP_STOCK_uPDATE where srno=@count1)'

EXEC (@SQL)

answered Jun 20, 2013 at 11:16

NigelK

8,4902 gold badges33 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get column value from dynamically achieved column name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related