topic Script Problem in Water Cooler

Script Problem

Mon, 14 May 2012 02:50:32 GMT

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;

Script Problem

spsrk_84 — Mon, 14 May 2012 06:36:25 GMT

Hi,

rtrim(DT_DeputyLName) + ', ' + rtrim(DT_DeputyFName) as DeputyName,
Chnage this statement to

rtrim(DT_DeputyLName) &', ' & rtrim(DT_DeputyFName) as DeputyName,

hope this works..

Thanks,

Shivaram