Ad-hoc Reporting

Ad-hoc Reporting

Watch 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

Audience

Analyst
DB Admin
Developer
Manager

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

900x675
21.4 MB

800x600
21.1 MB

320x240
10.1 MB

320x240
17.0 MB

Viewer Comments

thanks its a great video

xxd4v3gxx on June 09, 2009 2:50 PM.

Atleast now i now exporting data to an excel for a start...!!! Thanks.

on December 13, 2009 1:21 AM.

It is great presentation and very good clarity of the video and I really appreciate for that.

Sai on January 14, 2010 2:56 PM.

good thing

sand on March 17, 2010 9:19 AM.

Unbelievably Outstanding!!!!!!!!!!!!!!!!1

Shariqu on May 29, 2010 9:57 AM.

great

on August 16, 2010 1:59 AM.

Its mind blowing..Thanks for this video

on September 08, 2010 12:27 AM.

excellent video quality and good presentation.... keep it up...:)

shiva on January 08, 2011 4:07 AM.

It was shortly and to the point but great! Thanks

Tysap on March 17, 2011 2:47 PM.

excellent , lot of thanks

Shastri on September 10, 2011 10:32 AM.

Thanks for the great video :)

on September 22, 2011 4:52 PM.

Thanks alot - your answer solved all my problems after several days struglging

Hank on October 04, 2011 12:29 AM.