Tracking Changes in Description field of ASCL

[Former Member]

Hi,

My following query gives me information on changes in description field for each instance but in each new log instance it would show information from previous entries in description field and append new changes in new log instances. Is there a way where I can just show what was added to description field in just that log instance?

select t0.loginstanc,t0.origin,U_Name, t0.callid,descrption,t0.usersign2,t0.updateDate,t0.updatetime from ASCL t0

left join OUSR t1 on t0.usersign2=t1.userid

where callID=38499

many thanks.

[Former Member]

Hi,

Run this simple query. What do you get?

select distinct T0.descrption from ASCL t0

where callID=38499

Thanks,

Gordon

[Former Member]

hi,

I get the following error in SAP

"The ntext data type cannot be selected as DISTINCT because it is not comparable"

When I run the query.

[Former Member]

Try:

select distinct left(T0.descrption,200) from ASCL t0

where callID=38499

[Former Member]

Thank you for more suggestions but I get the same error as before.