Home > Archive > microsoft.public.cert.mcdba > July 2005 > query improvement for performance





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author query improvement for performance
sbharati

2005-07-26, 11:47 am

'AMOUNT' = CASE WHEN tbEXE.DebitFlg = 0 THEN ((CASE WHEN (tbEB.SwiftCd IS
NOT NULL AND tbEB.SwiftCd<>tbEB.Base_Curr_CD)

THEN tbEXE.ForeignAmt ELSE tbEXE.ExpenseEntryAmt END) * (-1)) ELSE
(CASE WHEN (tbEB.SwiftCd IS NOT NULL AND tbEB.SwiftCd<>tbEB.Base_Curr_CD)

THEN tbEXE.ForeignAmt ELSE tbEXE.ExpenseEntryAmt END) END

How can I write this query better.... this is used in one of my SPs


Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net