tags:

views:

27

answers:

0

Can any one of you help me to convert this query into dynamic query

DECLARE @Measure_Code nvarchar(50)


DECLARE @Transaction_Date datetime

DECLARE @Spec_Code nvarchar(max)

DECLARE @Error_Code nvarchar(500)

DECLARE @Operation_Status bit

DECLARE @Qury nvarchar(1000)

SET @Measure_Code = 'CFL_WATTS'

SET @Transaction_Date = 02/16/2010

PRINT @Transaction_Date

SET @Spec_Code = 'CFL_Watts = 45'

SET @Error_Code = NULL 

SET @Operation_Status = NULL

SET @Qury =  'USP_TRM_MEASURE_EVALUATE ' + '@Measure_Code'+','+'@Transaction_Date'+','+'@Spec_Code'+','+
                '@Error_Code output'+','+'@OPERATION_STATUSoutput'

PRINT @Qury

EXEC(@Qury)

I want the output as

@QURY = USP_TRM_MEASURE_EVALUATE @MeasureCode,@Transaction_Date, @Spec_Code, @Error_Code output, @Operation_Status output