transact sql -- Transamt

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
 
E

Eric R

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.
 
Top