cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Alert for new BP

Former Member
0 Likes
119

Hi Guys,

Please give me a query to create

Alert for new BP

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Likes

Hi Nithin,

Try this

SELECT T0.[CardCode], T0.[CardName],T0.

[CreateDate], T0.[UpdateDate], T1.[U_NAME]

as 'Last Updated User', T0.[CreditLine] FROM OCRD  T0 , OUSR

T1 WHERE t1.USERID=t0.usersign2 and DateDiff(DD,T0.[UpdateDate],GETDATE()) =0

Former Member
0 Likes

Thanks Ajith for fast reply

Answers (0)