• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

Create Table based off SPROC

I have a front end web part in SharePoint that only pulls from tables or views. The problem is, the data comes from a SPROC.

How can I call the SPROC from a view or table and how will the view/table stay updated?

Thanks.
0
LCNW
Asked:
LCNW
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
you can create a table with the same structure the sp returns , then you can insert the data like this

insert tableName
exec spName @params
0
 
LCNWAuthor Commented:
How does the table stay up-to-date? Would I need to create a SQL Job?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>How can I call the SPROC from a view or table
in short: you cannot.

you can only run a regular job to re-update the table from the table's output.
there may be issues about the data view during the procedure running (how much time does the proc take?)

maybe you could make a function instead of the proc?
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now