Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Using Sparse Columns with SELECT ... INTO Expand / Collapse
Author
Message
Posted Tuesday, August 28, 2012 11:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:55 PM
Points: 6,582, Visits: 8,860
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
Posted Tuesday, August 28, 2012 11:37 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 2, 2014 7:24 PM
Points: 286, Visits: 572
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.

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
Posted Tuesday, August 28, 2012 11:57 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
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
Posted Wednesday, August 29, 2012 1:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Greate question Wayne..got to learn something new today

~ 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
Posted Wednesday, August 29, 2012 1:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:06 PM
Points: 2,551, Visits: 1,614
Good question. thanks.
Post #1351441
Posted Wednesday, August 29, 2012 3:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
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
Posted Wednesday, August 29, 2012 5:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 11,192, Visits: 11,091
Good question, Wayne.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1351522
Posted Wednesday, August 29, 2012 5:16 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:29 AM
Points: 1,760, Visits: 2,136
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.
Connect to me on LinkedIn
Post #1351523
Posted Wednesday, August 29, 2012 6:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 1,307, Visits: 2,476
Good question. Thanks.


Sujeet Singh
Post #1351544
Posted Wednesday, August 29, 2012 6:10 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: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
This was a great question. Had to do a lot of research, since I was not familiar with SPARSE, to get this one right.
Post #1351545
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse