Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » STUFF - 2
Add to briefcase
33 posts, Page 1 of 4
1234»»»

STUFF - 2 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
bitbucket-25253
Posted Saturday, December 08, 2012 11:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 5,103, Visits: 20,215
Comments posted to this topic are about the item STUFF - 2

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read
Post #1394346
Lokesh Vij
Posted Monday, December 10, 2012 12:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:24 AM
Points: 1,176, Visits: 1,253
Thank you for another good question Ron!

NULL value will also be returned in the below two conditions:

-- When starting position is negative
SELECT STUFF(@str, -1,5,@stx)
-- When starting position is greater than the expression length => LEN(@str)
SELECT STUFF(@str, 7,5,@stx)

~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter
Post #1394468
Stewart "Arturius" Campbell
Posted Monday, December 10, 2012 12:21 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 3,129, Visits: 4,312
Interesting question, Thanks, Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1394469
paul s-306273
Posted Monday, December 10, 2012 1:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,161, Visits: 642
Guess you have to know your stuff to get today's QOTD right...
Post #1394481
kalyani.k478
Posted Monday, December 10, 2012 2:00 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616, Visits: 97
Simple question to start on monday:)
Post #1394488
Koen Verbeeck
Posted Monday, December 10, 2012 2:38 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473
Nice question, thanks.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1394503
rhythm.varshney
Posted Monday, December 10, 2012 3:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 21, 2013 2:14 AM
Points: 77, Visits: 184
Nice question.However it will fetch error in SQL 2005 not sure about upper version as we can not assign value while declaration.
Post #1394515
sipas
Posted Monday, December 10, 2012 4:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 14, 2013 12:20 PM
Points: 108, Visits: 206
More STUFFing - it must be nearly Christmas. Thanks for the question.
Post #1394530
(Bob Brown)
Posted Monday, December 10, 2012 4:21 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100
Thanks for the great Monday morning question.
Post #1394537
Toreador
Posted Monday, December 10, 2012 4:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761
The explanation is fine for the second example.
But there's no mention of why a NULL value for 'replace with' returns a non-null result.
This confused me when I first came across it, and confuses me still!
Post #1394550
« Prev Topic | Next Topic »

Add to briefcase
33 posts, Page 1 of 4
1234»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.