Home Forums SQL Server 2008 T-SQL (SS2K8) Random Values between 0.25-6.5 RE: Random Values between 0.25-6.5

  • September 2, 2016 at 5:40 am

    #1898966

    ammit.it2006 (9/1/2016)

    Nice one. Really, We don't need to run one by one...........

    Thanks

    This hsould do the trick

    Value = ((select ABS(CAST(NEWID() AS binary(6)) %25)) +1) *0.25

    How to post data/code on a forum to get the best help.