transact sql -- Transamt

  • Thread starter Thread starter Param
  • Start date Start date
P

Param

Please help. I have a select query where I am getting
this error.
Server: Msg 195, Level 15, State 10, Line 1
'TransAmt' is not a recognized function name.

The query is:
SELECT LFCLOSED_TXT.CoCode, LFCLOSED_TXT.AcctNo, CJDate
(TransAmt([RemvDate],7)*100) AS Remv,
LFCLOSED_TXT.ReferenceNo, LFCLOSED_TXT.TransCode, TransAmt
([ItemAmt],10) AS Amount, CJDate(TransAmt([AsOfDate],7)
*100) AS AsOf, CJDate(TransAmt(IIf(IsNull([DueDate]),
[AsOf],[DueDate]),7)*100) AS Due, CJDate(TransAmt(IIf
(IsNull([AgingDate]),[AsOf],[AgingDate]),7)*100) AS Aging,
LFCLOSED_TXT.XRefNo, TransAmt([Adjustments],10) AS AdjAmt,
LFCLOSED_TXT.RsnCode
FROM LFCLOSED_TXT;

I am an Oracle person, where I do not know lot about
Transact SQL, it was run before with no problems?? Can any
one look at it and let me know how I can change the above
query to get the same expected results since it is not
accepting Transamt as a function.

When I run the query, the status on the Windows Task
manager is showing that it is not responding.

Thanks in advance for your help.
Param
 
The problem is your use of "(TransAmt([RemvDate],7)*100)
AS Remv". "TransAmt" is not a Transact SQL function. More
then likely if it was working in the past, someone had
created a User-Defined Funtion (UDF) in the database.
Hope that helps you in some way.

Good Luck,
- Eric Ritzie, MCP
IT Manager - The Kramer Group, Inc.
 
Back
Top