Variable Syntax for User Input

Question

Post reply

Variable Syntax for User Input

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Create proc MyProc @Operator as varchar(2), @EquipmentCount as INT,

AS

Set nocount on

select count (*) as carrier_count from dbo.v_MTSTM_EquipmentCountByCarrier where 0 <

case when @Operator = '<' and equipment_count ' and equipment_count > @EquipmentCount then 1

when @Operator = '=' and equipment_count = @EquipmentCount then 1

...

else 0 end

set nocount off

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 2

SET @sSQL = @Statement + @Operator + CONVERT(nvarchar,@EquipmentCount)

Andy

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

You don't need dynamic sql to do this task, please stay away from it.

AVB SSChampion Points: 11418 More actions · Answer 4

Thanks for the suggestions. Dynamic SQL is new to me. I still have been unsuccessfull. I need to read about the code both of you have supplied so I may understand exactly what is happening. I'll post what I end up with. And feel free to post any other suggestions! Thanks again for your time!!!!!!!!