How do I Set a defined variable = fieldname?

[AndyB2]

Newbee SQL question, how do I set a variable = field name? getting Msg 207 error on the Set line below.

declare @TempProduction as int,
		@TempTimeStamp as date,
		@TempQuality as int,
		@TempMachineName as varchar(50)
select
Production,
TimeStamp1,
Quality,
MachineName,
@TempProduction
From dbo.testwide
where MachineName = 'a'
set 	@TempProduction = Production
--		@TempTimeStamp = TimeStamp1,
--		@TempQuality = Quality,
--		@TempMachineName = MachineName
--from dbo.testwide

When I use an integer, say 26, instead of the field name "Production " I do not have an error.

[ck9663]

Here, read this...

Happy Coding!!!


~~ CK