InvestorTrade wrote:

> I have a query that is formed dynamically, and I need to be able
> store the result in a variable, and example of this would be:
>
> BEGIN
>
> DECLARE @myresult int
> DECLARE @query = 'select count(*) from sysobjects'
>
> SET @myresult = exec (@query)
>
> END
>
> I thought of using Global temporary tables (##) where I could store
> the result, but I rather not.

On Jun 15, 6:16 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> InvestorTrade wrote:
> > I have a query that is formed dynamically, and I need to be able
> > store the result in a variable, and example of this would be:
>
> > BEGIN
>
> > DECLARE @myresult int
> > DECLARE @query = 'select count(*) from sysobjects'
>
> > SET @myresult = exec (@query)
>
> > END
>
> > I thought of using Global temporary tables (##) where I could store
> > the result, but I rather not.
>
> Can you replace the query with a stored procedure?

On Jun 15, 2:41 pm, InvestorTrade <shij...@gmail.com> wrote:
> Hi,
>
> I have a query that is formed dynamically, and I need to be able
> store the result in a variable, and example of this would be:
>
> BEGIN
>
> DECLARE @myresult int
> DECLARE @query = 'select count(*) from sysobjects'
>
> SET @myresult = exec (@query)
>
> END
>
> I thought of using Global temporary tables (##) where I could store
> the result, but I rather not.
>
> Thank you for any help,
>
> James.

James.Shih.Neulion@gmail.com wrote:

> On Jun 15, 6:16 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
>> InvestorTrade wrote:
>>> I have a query that is formed dynamically, and I need to be able
>>> store the result in a variable, and example of this would be:
>>> BEGIN
>>> DECLARE @myresult int
>>> DECLARE @query = 'select count(*) from sysobjects'
>>> SET @myresult = exec (@query)
>>> END
>>> I thought of using Global temporary tables (##) where I could store
>>> the result, but I rather not.
>> Can you replace the query with a stored procedure?
>
> Yes, but how would a store procedure help? I need to store the result
> of the query

On Jun 18, 7:52 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> James.Shih.Neul...@gmail.com wrote:
> > On Jun 15, 6:16 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> >> InvestorTrade wrote:
> >>> I have a query that is formed dynamically, and I need to be able
> >>> store the result in a variable, and example of this would be:
> >>> BEGIN
> >>> DECLARE @myresult int
> >>> DECLARE @query = 'select count(*) from sysobjects'
> >>> SET @myresult = exec (@query)
> >>> END
> >>> I thought of using Global temporary tables (##) where I could store
> >>> the result, but I rather not.
> >> Can you replace the query with a stored procedure?
>
> > Yes, but how would a store procedure help? I need to store the result
> > of the query
>
> Because you can feed the output of the stored procedure into a
> (non-global) temporary table. Quick example:
>
> create procedure foo as
> begin
> select bar, baz from the_table
> end
>
> create table #foo (bar int, baz varchar(10))
>
> insert into #foo exec foo
>
> select * from #foo

James.Shih.Neulion@gmail.com wrote:

> OK - Yes - I knew about the temporary table and already thought about
> this too - but I don't want to use it - I think it might be cheaper to
> use memory than creating a temp table in the drive - unless temp
> tables are created in memory. Thank you for the suggestion, any other
> way you may think of?