Scrip to export excel file in a Loop

Script to Get Exl Output in a Do while loop. Example taken is Authors table in PUB database, where excel is generated for each state the file in state name.U can modify the script to include filename in u'r format (eg. state + date)

2005-12-02 (first published: )

992 reads

Blogs

Interview with Greg Low

By

This is the sixth interview we have done. This time our guest is Greg...

Azure SQL Database Types

By

I want to do a quick summary post of the many different types of...

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Which items can be built (do we have enough product for)?

By pietlinden

I have a stupid question. I'm dealing with a Bill Of Materials problem... I...

Modifying the Dataframe in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Modifying the Dataframe in R

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers