Typical Requirement
-
Need Query for this requirement. The data in my table is as follows Zip Blac White green 123 1.76 2.04 1.00 234 3.49 2.39 3.24 Need Columname as output if the column value is > 2 for given zipcode. For example.if i give zip as "123" the query has to find out the value among the columns which is > 2. i.e White If i give zip as "234" then the query has to find out the value among the columns which is > 2. But here all values are > 2. So you have to pick the max value. i.e 3.49 = Blac
G. Satish
-
Need Query for this requirement. The data in my table is as follows Zip Blac White green 123 1.76 2.04 1.00 234 3.49 2.39 3.24 Need Columname as output if the column value is > 2 for given zipcode. For example.if i give zip as "123" the query has to find out the value among the columns which is > 2. i.e White If i give zip as "234" then the query has to find out the value among the columns which is > 2. But here all values are > 2. So you have to pick the max value. i.e 3.49 = Blac
G. Satish
What have you managed to come up with so far? I'd imagine there are quite a few different solutions to this problem so if you show what you have so far I'll try and help from there.
-
Need Query for this requirement. The data in my table is as follows Zip Blac White green 123 1.76 2.04 1.00 234 3.49 2.39 3.24 Need Columname as output if the column value is > 2 for given zipcode. For example.if i give zip as "123" the query has to find out the value among the columns which is > 2. i.e White If i give zip as "234" then the query has to find out the value among the columns which is > 2. But here all values are > 2. So you have to pick the max value. i.e 3.49 = Blac
G. Satish
Hi,I hope i understood you good enought. Here is TSQL solution which I hope will works for you.
select * from mytable declare @zip as int set @zip = 123 declare @white as varchar(100) set @white =(select white from mytable where zip=@zip) declare @black as varchar(100) set @black =(select black from mytable where zip=@zip) declare @green as varchar(100) set @green =(select green from mytable where zip=@zip) create table #temptable (valstr varchar(100),colname varchar(100)) insert into #temptable values (@white,'white') insert into #temptable values (@black,'black') insert into #temptable values (@green,'green') declare @colname as varchar(100) set @colname=( select top 1 colname from #temptable order by valstr desc ) drop table #temptable declare @selectquery as nvarchar(max) set @selectquery ='select '+@colname+' from mytable where zip='+cast(@zip as varchar(10)) exec(@selectquery)
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.