<div>
you can't name it dynamically w/o dynamic SQL...<br />
<br />
ALTER PROCEDURE [dbo].[SM_Letters]<br />
(@FieldName varchar(20))<br />
as<br />
select ViolNum as [Case_Number],<br />
&nbsp; &nbsp; &nbsp; &nbsp;FolioNum,<br />
&nbsp; &nbsp; &nbsp; 'SomeLiteral' = CONVERT(VARCHAR(10), &nbsp;@FieldName, 101) <br />
FROM smt_CaseInfo<br />
WHERE CONVERT(VARCHAR(10), @FieldName, 101) &nbsp;= CONVERT(VARCHAR(10), GETDATE(), 101)
</div>


<div>
ok i did it dynamic SQL but it trows an error:<br />
<br />
i called &quot;SM_Letters 'LetAdjOnlyFinalOrderDt'&quot;<br />
<br />
and this is the result:<br />
Msg 137, Level 15, State 2, Line 4<br />
Must declare the variable '@FieldName'.
</div>


<div>
post the exact code you used...
</div>


<div>
here is the Stored procedure:<br />
ALTER PROCEDURE [dbo].[SM_Letters]<br />
(@FieldName varchar(30))<br />
as<br />
declare @x nvarchar(2000)<br />
set @x = '<br />
select ViolNum as [Case_Number],<br />
&nbsp; &nbsp; &nbsp; &nbsp;FolioNum,<br />
&nbsp; &nbsp; &nbsp; CONVERT(VARCHAR(10), @FieldName , 101) as ' + @FieldName + '<br />
FROM smt_CaseInfo<br />
WHERE CONVERT(VARCHAR(10), @FieldName, 101) &nbsp;= CONVERT(VARCHAR(10), GETDATE(), 101) '<br />
exec sp_executesql @x<br />
<br />
and here is the call:<br />
SM_Letters 'LetAdjOnlyFinalOrderDt'
</div>


<div>
ALTER PROCEDURE [dbo].[SM_Letters]<br />
(@FieldName varchar(30))<br />
as<br />
declare @x nvarchar(2000)<br />
set @x = '<br />
select ViolNum as [Case_Number],<br />
&nbsp; &nbsp; &nbsp; &nbsp;FolioNum,<br />
&nbsp; &nbsp; &nbsp; CONVERT(VARCHAR(10), @FieldName , 101) as ' + @FieldName + '<br />
FROM smt_CaseInfo<br />
WHERE CONVERT(VARCHAR(10), ' + @FieldName + ', 101) &nbsp;= CONVERT(VARCHAR(10), GETDATE(), 101) '<br />
exec sp_executesql @x
</div>


<div>
that did not work.<br />
<br />
this works:<br />
ALTER PROCEDURE [dbo].[SM_Letters]<br />
(@FieldName varchar(30))<br />
as<br />
declare @x nvarchar(2000)<br />
set @x = '<br />
select ViolNum as [Case_Number],<br />
&nbsp; &nbsp; &nbsp; &nbsp;FolioNum,<br />
&nbsp; &nbsp; &nbsp; CONVERT(VARCHAR(10), ' + @FieldName + ', 101) as ' + @FieldName + '<br />
FROM smt_CaseInfo<br />
WHERE CONVERT(VARCHAR(10), ' + @FieldName + ', 101) &nbsp;= CONVERT(VARCHAR(10), GETDATE(), 101) '<br />
exec sp_executesql @x
</div>


<div>
sorry..missed that first variable...I can't run the statements myself, so I have to just eyeball it...glad to see once you fixed it that it works though.
</div>


<div>
this idea was the right one therefore i credit it with the points. Thank you for your quick response<br />
jsctechy
</div>


<div>
<div class="content wysiwyg-content">
hi, <br />
How can i rewrite this query to do this:<br />
ALTER PROCEDURE [dbo].[SM_Letters]<br />
(@FieldName varchar(20))<br />
as<br />
select ViolNum as [Case_Number], <br />
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FolioNum, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONVERT(VARCHAR(10), &nbsp;@FieldName, 101) as @FieldName<br />
FROM smt_CaseInfo<br />
WHERE CONVERT(VARCHAR(10), @FieldName, 101) &nbsp;= CONVERT(VARCHAR(10), GETDATE(), 101)
</div>
</div>


hi, 
How can i rewrite this query to do this:
ALTER PROCEDURE [dbo].[SM_Letters]
(@FieldName varchar(20))
as
select ViolNum as [Case_Number], 
 	FolioNum, 
	CONVERT(VARCHAR(10),  @FieldName, 101) as @FieldName
FROM smt_CaseInfo
WHERE CONVERT(VARCHAR(10), @FieldName, 101)  = CONVERT(VARCHAR(10), GETDATE(), 101)

how to pass a variable ino a column name (easy)

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.