1 Reply Latest reply: May 14, 2012 2:36 AM by Shivarama krishna K RSS

    Script Problem

      I am getting data in the table but I am getting no data in the new DeputyName field.  Here is an abstract of the script.  Any help would be greatly appreciated.  Thanks.
      DeputyTable:
      LOAD DT_DeputyFName,
      DT_DeputyLName,
      rtrim(DT_DeputyLName) + ', ' + rtrim(DT_DeputyFName) as DeputyName,
      DT_DeputyNum as DeputyNum,
      DT_Inactive;
      SQL SELECT DT_DeputyFName,
      DT_DeputyLName,
      DT_DeputyNum,
      DT_Inactive
      FROM dbo.DeputyTable;