Skip to Content
0
Former Member
Sep 24, 2010 at 04:17 AM

How to add System variable in a Query

233 Views

Hi Experts,

In ref. to the below query.

(SELECT T0.[CardCode], T0.[CardName], T0.[DocNum],T0.[Installmnt], T0.[DocDate], T0.[DiscPrcnt], T0.[DiscSum], T0.[DocTotal] FROM [dbo].[OINV]  T0 WHERE T0.[CardName] = [%0] )

Can you please let me know how to add a System Variabe (i.e., AR Invoice --> Total before discount field --> Variable : 85) to the above query.

Thanks in advance

Regards,

Rakesh N