this is my first sp

create proc createSp1(@acc varchar(20),@columnname varchar(25))

as

declare @value flaot;

set @query='select top 1 @value='+@columnname+' distict where DISTRICT='+@District;

-- select @query;

EXEC sp_executesql @query,N'@value nvarchar OUTPUT',@value OUTPUT;

select @value +100;

end...

Eirikur Eiriksson thanx for quick reply.

can you please provide me example.