Ad-hoc Reporting
Description
Need a quick way to export data returned by SQL Queries to a non-technical user, but don't want to have to set up a complex reporting package? In this video tutorial we'll show you how to quickly and easily configure SQL Server Query Analyzer and SQL Server Management Studio to export query results than can be painlessly imported into Microsoft Excel. Use this handy trick to provide co-workers or clients with the adh-hoc data they need - without giving them access to your production servers or without requiring them to learn T-SQL.
This Video Covers
Reporting, Query Output, Query Analyzer, and SQL Server Management Studio.
Details
Length: 08:27
Skill Level: 100 - Beginner.
Series: Tips and Tricks
Author: Michael K. Campbell
Applies to SQL Server: 2000, 2005, and 2008.
Tags: Tips and Tricks, Easy, Reporting, and T-SQL.
Code Download: 18 KB
Video Resources
Video References, Video Transcript, and Accompanying Source Code.
Related Videos
Using SQL Server Templates, Extra-Wide Covering Indexes, and Nibbling Deletes
Viewer Comments
SQL Server Videos are available free of charge.
But you must agree to the following terms before downloading:
Redistribution is prohibited.
Redistribution via any of the following means is prohibited.
• WebServer/HTTP, FTP,
• YouTube and similar sites,
• BitTorrent,
• CD/DVD, Portable Hard-drive, etc.
I already Agreed to these Terms
Non-registered users must agree to terms upon each new visit to the site.
Registration costs nothing, is painless, and is evil-free™. And SSV will never divulge your personal information to third parties. Ever.
Registered Users
Login Here.
thanks its a great video
Atleast now i now exporting data to an excel for a start...!!! Thanks.
It is great presentation and very good clarity of the video and I really appreciate for that.
good thing
Unbelievably Outstanding!!!!!!!!!!!!!!!!1