Formatted Search on a UDT

[Former Member]

Hi,

I am trying to create a FMS that applies only to a specific row which I am currently working on.

Here is my SQL statement:

SELECT

SUM((CASE WHEN $[@CHECKSMONITORING.U_ACCTG_TREA] IS NOT NULL THEN 1 ELSE 0 END)+

(CASE WHEN $[@CHECKSMONITORING.U_TREA_EXEC] IS NOT NULL THEN 1 ELSE 0 END)+

(CASE WHEN $[@CHECKSMONITORING.U_EXEC_TREA] IS NOT NULL THEN 1 ELSE 0 END)+

(CASE WHEN $[@CHECKSMONITORING.U_TREA_PAYEE] IS NOT NULL THEN 1 ELSE 0 END))

I dont know if I am just missing the "WHERE" part but I dont know too what will be the where condition that I should add so that it only considers tha values of the current row Im working on. Whenever I try to use the above FMS, it only returns and looks up the values of the very first record in the UDT.

Hoping someone can help me on this.

Thanks,

Mark

[kothandaraman_nagarajan]

Hi,

Please refer this thread

Thanks & Regards,

Nagarajan