I'm trying to parameterize the database name for use in calling a MSSQL stored proc:

SQL SQLMSS
EX &&DBNAME.dbo.spMyProc;

I have set the &&DBNAME = 'HEPBIDEV'. WF, clever as it is, interprets the period as a WF format and concatenation and says "Could not find stored procedure 'HEPBIDEVspMyProc'. How can I avoid the concat?

Hi,

To avoid the concat you have to change the context inside your stored procedure.example :
use databasename.

Majid.

well, that's one way to do it, but you'd have to add a parameter to every stored procedure to know if it's a test db or prod. i'd rather change my WF code instead of every SP. I've been able to do it like this:
-SET &proc = &&DBNAME | '.dbo.spMyProc'
SQL EX &proc;

any shortcuts to this?

Believe it or not, two dots (or three) after the variable name will work.

It's three dots:

-SET &&DBNAME = 'EIDW';

SQL SQLMSS

EX &&DBNAME...DBO.SPMYPROC;
-RUN

Excellent. that's what I was looking for. Thanks Francis.