Post reply

Output

  • April 23, 2007 at 12:44 pm

    #123670

    I want to generat output of the result into Excel how should I do inside the SP?

    the output of the query should go to c:\information.xls inside the SP.

    for example

    create proc inform

    as

    select name, address, city, state

    from address

    --exec inform

     

    NIta

     

  • April 23, 2007 at 2:18 pm

    #702020

    Check out the section on BCP titled "bcp utility, copying data from query to data file" from BOL.  I think you may be able to find your solution there.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply