Export a query to separate excel files

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Export a query to separate excel files

Author

Topic

ChrisHorsley
Starting Member

7 Posts

Posted - 2004-08-20 : 07:42:15

I'm trying to find away to loop through my export so that each query is run using the EmployeeID as a variable and each excel file is named using the EmployeeID.

The query below works fine manually but I don't want to enter every EmployeeID by hand... Please help me!

Here is my current Query: 'E705327' is the EmployeeID

SELECT
Sales.Quarter02.[ProjectName ],
Sales.Quarter02.[ReportNo ],
Sales.Quarter02.[Valuation ],
Sales.Quarter02.[Stage ],
Sales.Quarter02.[ProjectType ],
Sales.Quarter02.[Address ],
Sales.Quarter02.[City ],
Sales.Quarter02.[County ],
Sales.Quarter02.[State ],
Sales.Quarter02.[ZipCode ],
Sales.Quarter02.[GC ],
Sales.Quarter02.[Architect ],
Sales.Quarter02.[Consultant ],
Sales.Quarter02.[ConsultingEngineer ],
Sales.Quarter02.[ElectricalEngineer ],
Sales.Quarter02.[MechanicalEngineer ],
Sales.Quarter02.[Owner ]

FROM Sales.SalesRep INNER JOIN
Sales.CountyEID INNER JOIN
Sales.Quarter02 ON Sales.CountyEID.State = Sales.Quarter02.[State ] AND Sales.CountyEID.County = Sales.Quarter02.[County ] OR
Sales.CountyEID.State = Sales.Quarter02.[State ] AND Sales.CountyEID.County = Sales.Quarter02.[City ] ON
Sales.SalesRep.EID = Sales.CountyEID.Rep1

WHERE (Sales.SalesRep.EID = 'E705327')

ORDER BY Sales.Quarter02.[Valuation ] DESC[/font=Verdana]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources