Forum Replies Created

Viewing 15 posts - 646 through 660 (of 13,878 total)

  • Reply To: How to substract value from its own column in same tabl through condition basis

    Nice try, but there are a few issues.

    1. You have not included a CREATE TABLE, but I was able to get that from your proc definition a few posts earlier

      2. ...

    February 5, 2024 at 9:14 am

    #4373452

  • Reply To: How to substract value from its own column in same tabl through condition basis

    I tried pasting that into SSMS and hitting F5, but got a parsing error.

    You clearly have not taken the time to read the article to which Jeff directed you. Or,...

    February 3, 2024 at 9:52 am

    #4372519

  • Reply To: Replace double quotes in derieved column SSIS

    This expression will do that:

    right(F,3) == "\" \""? replace(F,"\" \"","\""): F

    February 2, 2024 at 4:03 pm

    #4372151

  • Reply To: Replace double quotes in derieved column SSIS

    OK, just to be clear, are you saying that you want to change this

    "1234-28" "

    to this

    "1234-28"

    ?

    February 2, 2024 at 3:35 pm

    #4372148

  • Reply To: How Often Do You Update SSMS?

    Thomas Franz wrote:

    Still using SSMS 18.x since my second most important Addon (besides Redgate SQL Prompt) with the name SSMSBoost seems to be deprecated and there is no version that works...

    February 2, 2024 at 2:35 pm

    #4372038

  • Reply To: Replace double quotes in derieved column SSIS

    Note also that there is a difference between an empty string ("") and NULL.

    February 2, 2024 at 10:06 am

    #4371911

  • Reply To: Replace double quotes in derieved column SSIS

    Please try this:

    REPLACE( F , "\"", "" )

    February 2, 2024 at 10:03 am

    #4371910

    • Viewing 15 posts - 646 through 660 (of 13,878 total)