Posted by apothecary on 09/19/07 14:43

Hello

Newbie here.

Is there a way of creating a VIEW...using a stored procedure. I am
basically trying to create a view to return some data that I am
getting using a stored procedure.

I have created the procedure and when I execute this its working ok.
The stored procedure uses a datefrom and dateTo which I have set up by
tweaking the getdate() and getdate()-2.

In other words can you create a view like this

CREATE VIEW view_test
AS
exec proc_test
GO

Any help will be greatly appreciated.

Remmy

• Next in forum: Re: variables in constraints, scripting partition sliding
• Prev in forum: Nightly Refresh
• Thread view: Creating a View from a Stored procedure

[Reply to this message]