0 - 5 of 5 tags for variable
SELECT 
  vw_TPDDP.System_NME
  ,vw_TDAD.Date_YYYY_FMT
  ,vw_TDAD.Date_MM_FMT
  ,vw_TPDDP.Company_CDE
  ,SUM(vw_TPF.AMT) Amt
FROM 
  vw_TDAD 
   INNER JOIN vw_TPF 
   ON (vw_TPF.Date_DIM_ID=vw_TDAD.Date_DIM_ID)
   INNER JOIN vw_TPDDP 
   ON (vw_TPF.Profile_DIM_ID=vw_TPDDP.Profile_DIM_ID)
WHERE 
  (  vw_TDAD.Date_YYYY_FMT  =  '2015'

I have a query that I would like to avoid hard coding. Using the following example could you give me the code to create such a variable:

Hi,

Hi,

I got to know that I can use TPT ODBC Operator to select data from another ODBC DB and then load that data into TD DB, using the LOAD Operator.

Hi all,

In MySQL you can set a user defined variable like this:

set @varname = 'does_this_work';

select @varname;

How in the world is this done using TD?
and yes, I am new to TD.

Thanks Lau.