Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,246 total)

  • RE: Using Hex values

    Jeff Moden - Friday, February 16, 2018 11:20 AM

    Jason A. Long - Friday, February 16, 2018 10:23...

  • RE: Decimal place in SQL

    below86 - Friday, February 16, 2018 10:33 AM

    Jason A. Long - Friday, February 16, 2018 10:14 AM

  • RE: Using Hex values

    Jeff Moden - Friday, February 16, 2018 8:56 AM

    jasona.work - Friday, February 16, 2018 8:46 AM

    February 16, 2018 at 10:23 am

    #1980097

  • RE: Decimal place in SQL

    below86 - Friday, February 16, 2018 9:20 AM

    SELECT original_value,
        CAST(ROUND(CONVERT(INT, original_value) / 10.0, 0) AS DECIMAL(9, 3)) AS decimalvalue
    FROM (VALUES('0054880'), ('0054885'),...

  • RE: Today's Random Word!

    ZZartin - Friday, February 16, 2018 7:57 AM

    Ed Wagner - Friday, February 16, 2018 6:40 AM

    February 16, 2018 at 8:17 am

    #1980072

  • RE: Decimal place in SQL

    Depending on the actual requirements, something like this could work...

    IF OBJECT_ID('tempdb..#TestData', 'U') IS NOT NULL
    BEGIN DROP TABLE #TestData; END;

    CREATE TABLE #TestData (

  • RE: Today's Random Word!

    Ed Wagner - Thursday, February 15, 2018 12:51 PM

    ManicStar - Thursday, February 15, 2018 9:39 AM

    February 15, 2018 at 12:57 pm

    #1979985

  • RE: Today's Random Word!

    ZZartin - Thursday, February 15, 2018 8:32 AM

    Ed Wagner - Thursday, February 15, 2018 8:23 AM

    February 15, 2018 at 9:33 am

    #1979937

  • RE: Today's Random Word!

    Revenant - Thursday, February 15, 2018 6:36 AM

    Ed Wagner - Thursday, February 15, 2018 5:36 AM

    February 15, 2018 at 8:10 am

    #1979913

  • RE: Today's Random Word!

    Jeff Moden - Wednesday, February 14, 2018 5:25 PM

    ManicStar - Wednesday, February 14, 2018 12:59 PM

    February 14, 2018 at 7:15 pm

    #1979863

  • RE: Today's Random Word!

    ManicStar - Wednesday, February 14, 2018 8:34 AM

    Ed Wagner - Wednesday, February 14, 2018 5:29 AM

    February 14, 2018 at 9:17 am

    #1979762

  • RE: Today's Random Word!

    DesNorton - Monday, February 12, 2018 1:35 PM

    ManicStar - Monday, February 12, 2018 1:33 PM

  • RE: Today's Random Word!

    Ray K - Monday, February 12, 2018 10:02 AM

    ZZartin - Monday, February 12, 2018 9:25 AM

    February 12, 2018 at 12:18 pm

    #1979497

  • RE: help with substring

    mxy - Thursday, February 8, 2018 4:59 PM

    thanks, i do have a scenario where there will be combination 'or', 'and'. 
    if it is...

  • RE: datetime

    shwetakakran01 - Wednesday, February 7, 2018 4:58 AM

    your date format is not correct. it should be month/date/year. your are trying to do...

Viewing 15 posts - 421 through 435 (of 1,246 total)