I need a global variable for storing the no.of Decimal values for a number (variable).... Below is the scenario...
I have a store Procedure where I declare all the decimal numbers at the start as shown below
Declare @timeID as Decimal(15,3), Declare @BusinessID as Decimal(15,3)
I need a variable which stores the decimal count say
Declare @decimalcount as Integer, @decimalcount=3
which I can use it in all the declartion i have done like
Declare @timeID as Decimal(15,@decimalcount)
Declare @BusinessID as Decimal(15,@decimalcount)
so by changing the value at one place would change all the values in the code.... Is this possible ?