Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 8,761 total)

  • RE: Inline table-valued function to list numbers

    Jeff Moden (11/13/2016)


    TheTrojan (11/13/2016)


    @mister.magoo You will be happy to know that your solution is slightly faster than mine! Have a look at the times:

    -- if the parameter is 1000: 76...

  • RE: Replace uppercase words with bold

    Adi Cohn-120898 (11/15/2016)


    Here is one more way:

    declare @Org varchar(150) = 'Lorem ipsum dolor sit amet, CONSECtetur adipiSCIng elit. PelleNTesque in ELIT ut ex accumsan sagittis in a urna'

    declare @Results varchar(200)...

  • RE: Replace uppercase words with bold

    dothedev (11/15/2016)


    Wow, thanks! :w00t:

    Just needed to add some (finnish) characters in the IS_CAPS case and that's it!

    It's going to take a while to understand though 🙂

    You are very welcome.

    😎

    To...

  • RE: what is compile wait resource and how to resolve it

    farax_x (11/15/2016)


    GilaMonster (11/15/2016)


    You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down...

  • RE: SQL Query/JOB Error

    gunadi.arunanto (11/15/2016)


    or wich part can i change INT?

    Before changing anything, what is the output of this query?

    😎

    SELECT

    'dbo.MAP_MONTH' AS TABLE_NAME

    ,MAX(MM.SYS_ID) AS MAX_VAL

    FROM...

  • RE: SQL Query/JOB Error

    From what I can see, you will have to change the data type of the ID column in the MAP table to INT, currently it is NUMERIC(9,0) (999999999) which is...

  • RE: Replace uppercase words with bold

    dothedev (11/15/2016)


    I need to replace in given string all uppercase strings longer than two characters with lowercase and set html bold tags around them. Any leads?

    For example convert this:

    Lorem...

  • RE: Server Hangs

    s0da9 (11/14/2016)


    Ed Wagner (11/13/2016)


    s0da9 (11/13/2016)


    Adi Cohn-120898 (11/10/2016)


    Can you check the server's error log? By default it is configured to write into the error log details about failed logins. ...

  • RE: SQL Query/JOB Error

    Script the tables in question as shown in the picture and the post the generated scripts here

    😎

  • RE: how to remove characters char(0) to char(31)

    lady.konvicka (11/15/2016)


    hi i have this test code which replace our problem on production

    first replace for CHAR(0) removes character 'C' --- I dont know Why

    when u set input to for example...

  • RE: Are the posted questions getting worse?

    GilaMonster (11/15/2016)


    Eirikur Eiriksson (11/14/2016)


    I used to have the same problem in Iceland, blazing fast local but anything else would be crawling, here in London I'm getting around 985Mbs on the...

  • RE: How Do You Act When You Need to Learn New Technology?

    Jeff Moden (11/14/2016)


    Iwas Bornready (11/14/2016)


    Gary Varga (11/7/2016)


    ...or they could just continually lose staff with all their knowledge of both the business and it's workings then hire someone with none of...

  • RE: Are the posted questions getting worse?

    GilaMonster (11/14/2016)


    Eirikur Eiriksson (11/14/2016)


    GilaMonster (11/14/2016)


    Steve Jones - SSC Editor (11/14/2016)


    I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are...

  • RE: Are the posted questions getting worse?

    GilaMonster (11/14/2016)


    Steve Jones - SSC Editor (11/14/2016)


    I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup is you'll...

  • RE: SSMA Error: Unable to transfer display properties for column A because corresponding target object does not exist.

    omar4454 (11/14/2016)


    Hey everyone, can someone provide some light on this error, or how to go about troubleshooting? I am getting this error for about 5 columns. They are not in...

Viewing 15 posts - 2,716 through 2,730 (of 8,761 total)