How can we help you today? How can we help you today?

CAST function not being properly formatted like other functions, ie. ISNULL

            'FeedUpdate' + CAST(d.DocumentTypeId AS VARCHAR(40)) AS ConfigKey
          , CAST(a.CYContractYear AS VARCHAR(4)) + ' ' + d.DocumentTypeName AS ConfigValue
          , CAST(b.FeedId AS VARCHAR(2000)) AS Description

should have spaces around the parentheses but it doesn't
Donald Bouchard
0

Comments

4 comments

Sort by
  • DustinM
    Hello,

    We have recreated this on our end and are escalating it to the dev team to look into.

    Best,

    Dustin
    DustinM
    0
  • dpbouchard_aetna
    Thanks very much.
    dpbouchard_aetna
    0
  • DustinM
    Hello,

    We wanted to follow up on this one, our dev team has notified us they have placed this on their schedule to take a deeper look.

    Best,

    Dustin
    DustinM
    0
  • DustinM
    Hello, 

    I wanted to follow up with you on this bug, this should be resolved in the latest release of SQL Prompt.

    Best, 

    Dustin
    DustinM
    0

Add comment

Please sign in to leave a comment.