Export with Headers

Question

Export with Headers

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003869 More actions · Answer 1

Damn. I forgot all about this. I'll get started early next week. According to what Steve asked for in his OP, I'm thinking that I might be able to pull it off as a Spackle article.

Grant, what are you going to call yours? If we do it right, Steve can run them back to back or maybe even on the same day. Be really cool to have them similarly named especially if we consider what people might look for in a Google search on the subject.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 2

Jeff Moden (9/5/2013)
Damn. I forgot all about this. I'll get started early next week. According to what Steve asked for in his OP, I'm thinking that I might be able to pull it off as a Spackle article.
Grant, what are you going to call yours? If we do it right, Steve can run them back to back or maybe even on the same day. Be really cool to have them similarly named especially if we consider what people might look for in a Google search on the subject.

Ha! It's on my queue. Along with 20 other things. I'll see what I can do to bump it up. I'm easy on the title. Just say 'With X' at the end and we'll substitute PowersShell.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 3

Bump

Export data from a table(view/query) with Powershell. Include headers for easy reading.

Louis Li Right there with Babe Points: 798 More actions · Answer 4

Submitted.

----------------------------------------------------------------------------------------------
Microsoft Certified Solution Master: Data Platform, Microsoft Certified Trainer
Email: Louis.Li@rrlminc.com | Blog[/url] | LinkedIn[/url]

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 5

Louis Li (4/7/2014)
Submitted.

Louis, I see a script from you and that's good, but I'm still looking for an article with explanation of how to do this and how it works in a little more detail.

Louis Li Right there with Babe Points: 798 More actions · Answer 6

Sure, Steve.

----------------------------------------------------------------------------------------------
Microsoft Certified Solution Master: Data Platform, Microsoft Certified Trainer
Email: Louis.Li@rrlminc.com | Blog[/url] | LinkedIn[/url]

Louis Li Right there with Babe Points: 798 More actions · Answer 7

Steve Jones - SSC Editor (4/8/2014)
Louis Li (4/7/2014)
Submitted.
Louis, I see a script from you and that's good, but I'm still looking for an article with explanation of how to do this and how it works in a little more detail.

Submitted, Steve.

----------------------------------------------------------------------------------------------
Microsoft Certified Solution Master: Data Platform, Microsoft Certified Trainer
Email: Louis.Li@rrlminc.com | Blog[/url] | LinkedIn[/url]

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 8

Steve Jones - SSC Editor

SSC Guru

Points: 734459

April 24, 2014 at 10:51 am

#1708508

Thanks, I see it and I'll review it as soon as I can.