Re: Need help using parameters in FROM clause

Article View: comp.databases.ms-sqlserver

Article #58

Back to comp.databases.ms-sqlserver Previous Next

#58

From: Chris McKulka
Date: Thu, 06 Mar 1997 00:00

19 lines
931 bytes

Try:

declare @sqlStmt varchar(255)
select @sqlStmt='Select * from ' + @office
exec (@sqlStmt)


brent@ugcs.caltech.edu (Brent Eubanks) wrote:

>In SQL Server 6.5, I'm trying to write a stored procedure that takes a
>parameter and uses it in the FROM clause of a SELECT statement.
>ie:
>
>create proc test @office varchar(10) as
>
>select ...
>from @office
>where...

Technical Details

Message-ID: <331e4abb.9107034@news.oz.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <5fl1lo$bbe@gap.cco.caltech.edu>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,ce6f816d56eea647
X-Google-Attributes: gid104de1,public
X-Google-Thread: 11355a,ce6f816d56eea647
X-Google-Attributes: gid11355a,public
From: cmckulka@usa.net (Chris McKulka)
Subject: Re: Need help using parameters in FROM clause
Date: 1997/03/06
Message-ID: <331e4abb.9107034@news.oz.net>
X-Deja-AN: 223445089
References: <5fl1lo$bbe@gap.cco.caltech.edu>
Organization: Sense Networking (http://www.oz.net)
Newsgroups: comp.databases.ms-sqlserver,bit.listserv.sqlinfo

Reply to Parent Message