Returning TSQL Results straight to file.

From: Da Olive (doliver_at_mailbox.co.za)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 02:08:59 -0800

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?

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Prompting large number of records
    ... adamant that they want to pull all 45000 in and scroll through. ... I will view paging url to see if this will help. ... > the last option about paging through a stored procedure.. ... >> data to scroll through). ...
    (microsoft.public.vb.general.discussion)
  • Stored procedure to copy tables & also preserve indexing/schema
    ... that presently exist) that need to be copied from one database to another. ... For example there is a stored procedure called SP_RENAME. ... If not perhaps there is a way I can automatically pull (from my stored ... procedure) the ALTER commands to create the keys etc and execute them on the ...
    (microsoft.public.sqlserver.replication)
  • Re: Displaying international charachters
    ... "Nightcrawler" wrote: ... query to pull the data through a stored procedure. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Returning TSQL Results straight to file.
    ... > I'm creating a stored procedure to pull a report every morning for my ... > manager. ... > stored procedure to write it directly to the file. ... Write a DTS script and schedule it to run every morning: ...
    (microsoft.public.sqlserver.xml)
  • SqlDataReader and System.InvalidCastException
    ... I am using trying to get some data out of a SQL 2000 database via ... but I am getting some strange results. ... It will pull ... I have verified that the stored procedure is returning all values. ...
    (microsoft.public.dotnet.framework.adonet)