Pass (Send) Integer variable as Column Name to Select statement in SQL Server

Hi nagaraju60,

You have to execute using Dymanic query.

Check the below sample query.

SQL

CREATE TABLE TT_Screen(
[Rack_Id] [int] NOT NULL,
[Row_Name] [char](1) NOT NULL,
[1] [varchar](5) NULL,
[2] [varchar](5) NULL,
[3] [varchar](5) NULL,
[4] [varchar](5) NULL
)

INSERT INTO TT_Screen VALUES(9,'A',1,0,3,0)
INSERT INTO TT_Screen VALUES(9,'B',0,2,0,4)
INSERT INTO TT_Screen VALUES(9,'C',0,0,3,0)
INSERT INTO TT_Screen VALUES(9,'D',0,2,3,4)

DECLARE @Rack_Id VARCHAR(10), @Row_Name char(1), @Column varchar(5)
SET @Rack_Id = 9
SET @Row_Name = 'B'
SET @Column ='3'
DECLARE @DynQuery nvarchar(1000)
SET @DynQuery = N'SELECT [' + @Column + '] 
				FROM TT_Screen 
				WHERE Row_Name = '''+@Row_Name+''' AND Rack_Id = '''+@Rack_Id+''''
EXEC (@DynQuery)

GO

DECLARE @Rack_Id VARCHAR(10), @Row_Name char(1), @Column varchar(5)
SET @Rack_Id = 9
SET @Row_Name = 'C'
SET @Column ='3'
DECLARE @DynQuery nvarchar(1000)
SET @DynQuery = N'SELECT [' + @Column + '] 
				FROM TT_Screen 
				WHERE Row_Name = '''+@Row_Name+''' AND Rack_Id = '''+@Rack_Id+''''
Exec (@DynQuery)

Output

For first query output is 0.

For second query output is 3.