Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hidden Formatting Troubles with STR() (SQL Spackle) RE: Hidden Formatting Troubles with STR() (SQL Spackle)

  • January 7, 2014 at 4:56 pm

    #1678270

    Jeff Moden (1/7/2014)

    paul.goldstraw (1/7/2014)

    Thanks Jeff, makes sense. If someone asked me to right justify some text I think the quicker solution would be closer to what I would have attempted anyway as i'm more used to using those sorts of string manipulations, but at least now I know for sure it's the better implementation

    Thanks

    Paul

    That being said, I'll take that as a suggestion and modify the article to use spaces at first as a direct replacerment for STR() and then expose the ability to use other characters and the reasons why one might want to do so.

    Thanks for the feedback, Paul.

    Sounds like that's above and beyond the call of a Spackle article! 😛

    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St