[itdiscuss] SQL Transform Equivalent

[Derek Schwab]

Bobby, Could you use a stored procedure run on a schedule by the SQL agent? If you already have a query that does what you want, seem like that would be the best approach to run it on a scheduled bases.

-Derek

From: discuss-bounces at janoah.net [mailto:discuss-bounces at janoah.net] On Behalf Of Bobby Stewart
Sent: Monday, August 01, 2011 11:39 AM
To: IT Discussion Forum
Subject: [itdiscuss] SQL Transform Equivalent

In my past work with SQL Server 2000 I had occasion to use transforms to export data on a timed basis. I'm looking for a similar technique for SQL 2008 R2.

I have the query. Just no time export method.

Bobby Stewart
Network Analyst
Brentwood Baptist Church
Brentwood, TN
www.brentwoodbaptist.com<http://www.brentwoodbaptist.com>
+1 (615) 324-6149 office
+1 (615) 830-0012 cell

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://optimus.thompsonic.com/pipermail/discuss/attachments/20110801/344ab253/attachment.html>