Home Forums SQL Server 2008 SQL Server Newbies Converting CDbl to SQL RE: Converting CDbl to SQL

  • April 22, 2014 at 9:33 am

    #1707807

    Sean Lange (4/22/2014)

    t-sql doesn't have a double but you can easily get the results you are looking for.

    1/([NUM_STOP]-1.0) AS [TL Equivilent]

    Notice the 1.0 versus original 1 as t-sql will return int if the 1 is used.