AnsweredAssumed Answered

NSQL concatenate

Question asked by cshah on Oct 20, 2010
Latest reply on Oct 21, 2010 by cshah
Hello,

I have the code below and would like to concatenate Manager Last Name with Manager First Name, however not sure with two subqueries how can combine with NSQL?
@select:dim_prop:user_def:implied:mts:(SELECT   NBI_RESOURCE_CURRENT_FACTS.MANAGER_FIRST_NAME
                  FROM  NBI_RESOURCE_CURRENT_FACTS WITH (NOLOCK)
                  WHERE NBI_RESOURCE_CURRENT_FACTS.RESOURCE_ID = SRM_RESOURCES.ID):Manager_First_Name@,
@select:dim_prop:user_def:implied:mts:(SELECT      NBI_RESOURCE_CURRENT_FACTS.MANAGER_LAST_NAME
                  FROM  NBI_RESOURCE_CURRENT_FACTS WITH (NOLOCK)
                  WHERE NBI_RESOURCE_CURRENT_FACTS.RESOURCE_ID = SRM_RESOURCES.ID):Manager_Last_Name@           
FROM  SRM_RESOURCES WITH (NOLOCK), PRTIMEPERIOD WITH (NOLOCK)
I tried the below as a line right below the above statements but I believe I need the table.column format for it to recognize?
@select:dim_prop:user_def:implied:mts:(Manager_Last_Name+’, ‘+Manager_Firtst_Name):Manager_Full_Name@
Thank you in advance.

Outcomes