precision and scale in decimal(p,s)

• bilko73

  Old Hand

  Points: 377

  More actions

  July 23, 2002 at 10:32 am

  #79075

  I am having trouble setting precision and scale dynamically in a function:

  SET @RETURNIT = CAST(0.12121 AS DECIMAL(@P,@S))

  where @P and @S are declared as int and set with values.

  Is this not possible????

• Robert W Marda

  SSChampion

  Points: 13413

  More actions

  July 23, 2002 at 4:30 pm

  #433259

  I think the only way to do this is to build it dynamically in a variable and then execute the SQL in the variable. Something like this:

  DECLARE @p int, @S int, @RETURNIT decimal, @strSQL varchar(300)

  SET @p = 8

  SET @S = 6

  SET @strSQL = 'DECLARE @RETURNIT decimal(' + LTRIM(STR(@P)) +',' + LTRIM(STR(@S)) + ')

  SET @RETURNIT = CAST(0.12121 AS DECIMAL(' + LTRIM(STR(@P)) +',' + LTRIM(STR(@S)) + '))

  SELECT @RETURNIT'

  PRINT @strSQL

  EXEC (@strSQL)

  Robert Marda

  SQL Server will deliver its data any way you want it

  when you give your SQL Programmer enough developing time.

  Robert W. Marda
  Billing and OSS Specialist - SQL Programmer
  MCL Systems