Using Sparse Columns with SELECT ... INTO

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 Wayne Sheffield » Using Sparse Columns with SELECT ... INTO

28 posts, Page 1 of 3

1 2 3 »»»

Using Sparse Columns with SELECT ... INTO

Rate Topic

Display Mode

Topic Options

Author

Message

WayneS

Posted Tuesday, August 28, 2012 11:35 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:29 PM
Points: 6,367, Visits: 8,226

Comments posted to this topic are about the item Using Sparse Columns with SELECT ... INTO

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 #1351393

MissTippsInOz

Posted Tuesday, August 28, 2012 11:37 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:39 PM
Points: 286, Visits: 519

Hmm...an odd thing just happened. I know that I selected the correct answers for this question but then the response was that I'd answered it incorrectly and gave an explanation why one of the answers I didn't select was wrong. Maybe I've finally gone crazy - it had to happen someday. w00t

Great question anyway - Thanks!

Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)

Hey, just a thought.....did you check Books Online yet?

Post #1351395

Koen Verbeeck

Posted Tuesday, August 28, 2012 11:57 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364, Visits: 6,462

Great question Wayne, 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 #1351399

Lokesh Vij

Posted Wednesday, August 29, 2012 1:00 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:58 AM
Points: 1,169, Visits: 1,244

Greate question Wayne..got to learn something new today Smile

~ 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 #1351425

arthurolcot

Posted Wednesday, August 29, 2012 1:41 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:58 AM
Points: 1,721, Visits: 1,401

Good question. thanks.

Post #1351441

DugyC

Posted Wednesday, August 29, 2012 3:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:14 AM
Points: 1,160, Visits: 726

Today is a good day for an education.

Thanks for the great question, learned something new.

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"

Post #1351489

Paul White

Posted Wednesday, August 29, 2012 5:09 AM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

Good question, Wayne.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1351522

Thomas Abraham

Posted Wednesday, August 29, 2012 5:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 1,146, Visits: 1,448

Thanks for the question Wayne! I don't use XML in my current work, so I had to do a bit of guessing. Went with what seemed reasonable and got it right.

Please don't go. The drones need you. They look up to you.

Post #1351523