Using Query stored in database

[raynkel]

I store a query String..ie(Select * From Project, etc) in a database as a record. I want to call that query string and run it. I will send it the Record number and need to get back the results of the querystring that is in the database.

I could just do one call to get the string and then use that result to run another query, but that seems wasteful.
Any suggestions?

 

[swampBoogie]

Use a view or stored procedure instead.

 

[raynkel]

I am not sure how to set it up to do it. How do I run a QueryString that is stored as a record?

 

[raynkel]

--This works

SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
go
CREATE PROCEDURE [dbo].[sp_GetQueryResults]
@ReportNumber int
as
DECLARE @String varchar(8000)
SET @string = (SELECT QueryString FROM ReportQuerys where reportid = @ReportNumber)
exec (@string)
GO