Peter J. Boettcher — Sat, 09 Nov 2002 01:34:27 +0000

You're using sprocs?

If so it's pretty easy, just build your SQL string in the sproc, for example:

CREATE PROCEDURE dbo.SprocName
(
@Org_ID integer
)

SET NOCOUNT ON

DECLARE @Query varchar(1000)

SET @Query = 'SELECT COUNT(user_id) FROM Org_'
+ CAST(@Org_ID, char(4)) + '.dbo.Assignment_Requests
WHERE Org_' + CAST(@Org_ID, char(4)) + '.dbo.Assignment_Requests.org_id = ' + CAST(@Org_ID, char(4))

EXECUTE(@Query)

That should do it. Just make sure you validate the Org_ID otherwise it will fubar your sproc.