Re: Returning TSQL Results straight to file.

From: Bryant Likes (bryant_at_suespammers.org)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 07:20:54 -0800

"Da Olive" <doliver@mailbox.co.za> wrote in message
news:eTM2xElEEHA.3748@TK2MSFTNGP11.phx.gbl...
> Hi All
>
> I'm creating a stored procedure to pull a report every morning for my
> manager. The thing is she just wants to double click and open a file. I
> want to run a schedule every morning before she gets in, I want the
> stored procedure to write it directly to the file. Is this possible or
> is there another way to do it?

Write a DTS script and schedule it to run every morning:
http://www.sqlxml.org/faqs.aspx?faq=10 

--
Bryant

Relevant Pages

  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... You want to schedule or simply run/put them on a Q and they run? ... Again I would still connect to SQL Server however it is that you want to do it, get all the possible procs from your Control table. ... I want to write a stored procedure that will ... You also do not need to use a Script task to do ...
    (microsoft.public.sqlserver.dts)
  • Re: Limitations of Scheduled jobs
    ... > Actually we can schedule the jobs with accuracy less than ... where executing the stored procedure ... >>on what the stored procedure does exactly. ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Limitations of Scheduled jobs
    ... Actually we can schedule the jobs with accuracy less than ... >on what the stored procedure does exactly. ... >SQL Server MVP ... >> I'm using SQL Server 2000 as the DB for my web ...
    (microsoft.public.sqlserver.programming)
  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... I want to write a stored procedure that will ... And by schedule I mean run as a job now. ... You also do not need to use a Script task to do ... loop over them and execute them using a combination of the ForEachLoop ...
    (microsoft.public.sqlserver.dts)
  • Re: excecuting stored procedures
    ... Can I Schedule excecution of stored procedure in crystal report XI. ... You want to schedule the stored proc (I'm assuming on MSSQL?) to run based ... on a given time from within Crystal Reports? ...
    (microsoft.public.vb.crystal)