Concatenation Cursor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by D Sanborn » Concatenation Cursor

44 posts, Page 1 of 5

1 2 3 4 5 »»»

Concatenation Cursor

Rate Topic

Display Mode

Topic Options

Author

Message

sanbornd

Posted Monday, February 15, 2010 9:59 PM

Old Hand

Group: General Forum Members
Last Login: Monday, September 26, 2011 10:38 AM
Points: 331, Visits: 52

Comments posted to this topic are about the item Concatenation Cursor

Post #865846

Joy Smith San

Posted Monday, February 15, 2010 10:15 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 1,370, Visits: 2,285

It's a very good question. Realy useful.

Post #865850

Stewart "Arturius" Campbell

Posted Monday, February 15, 2010 10:28 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 3,123, Visits: 4,310

Good "back to basics" question

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #865853

ziangij

Posted Monday, February 15, 2010 11:35 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 2:53 AM
Points: 1,526, Visits: 359

thanks, a very good question ! got to learn something new today. Smile

Post #865867

Posted Tuesday, February 16, 2010 1:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 12:58 AM
Points: 174, Visits: 555

I have never been so glad to be wrong! I think some of my SPs with temp cursors may meet an end.

Post #865887

Clive Chinery

Posted Tuesday, February 16, 2010 1:50 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, September 02, 2011 3:22 AM
Points: 1,227, Visits: 154

An excellent question! Thank you for posting it!

Post #865896

Richard M Karpel

Posted Tuesday, February 16, 2010 4:08 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 30, 2011 3:44 AM
Points: 971, Visits: 62

This is a statement I use all the time in creating Dynamic SQL strings. It is great for use with pivot tables. Something I have been using for a while. Cool

Post #865962

WayneS

Posted Tuesday, February 16, 2010 5:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:32 PM
Points: 6,367, Visits: 8,224

Just remember that without an order by clause, there is no guaranteed order. The correct answer for this could have been just as easily "Bill, Mark, John".

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #866009

ronmoses

Posted Tuesday, February 16, 2010 5:39 AM

SSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 10:09 AM
Points: 648, Visits: 684

Wow, I never knew about this! I've got a few SPs to clean up this morning! Smile

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Post #866015

Juan de Dios

Posted Tuesday, February 16, 2010 5:59 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 9:05 AM
Points: 311, Visits: 110

This script is very useful when all the rows are not NULL, but if you modify the insert of Mark with NULL, the script only returns Bill.

insert into @table values (4, NULL,'M')

Result: Bill

Where John goes???

Post #866032

« Prev Topic | Next Topic »

44 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions