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.
LVL 1
LCNWAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor 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
 
Aneesh RetnakaranConnect With a Mentor Database 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.