Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: redirect output of a stored procedure to a table

    How to redirect output of a stored procedure to a table

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: redirect output of a stored procedure to a table

    Originally posted by vrsrinivas
    How to redirect output of a stored procedure to a table
    use a linked server/openquery as:
    insert into tableName
    select * FROM OPENQUERY(servername, 'exec procedurename')

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Are you trying to learn MS SQL or is this a Quiz !!! I would really want to know
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    What abotu this?

    create proc test
    as
    select getdate()
    go
    create table #table(today datetime)
    insert #table
    exec test
    select * from #table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •