on 2012 May 08 1:07 PM
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.