In the future, keep in mind that...

There's nothing wrong with your CAST solution, andresito. It works perfectly for getting rid of the spare change.

The reason(s) I used the modulo operator is that...

Perhaps its a limitation of the Pervasive db?

Happy to help. 🙂

It...

You mean like this? Or am I missing something?

DECLARE @X XML

SELECT @X = ( SELECT * FROM sampleTable FOR XML AUTO )

SELECT @X as [@X]

ARID = Alternate Reality ID.

I believe it's parameter 117, but I'd have to confirm that with Gail.

Paul's solution will work. Just don't confuse it with the following code which will NOT work, in violation of the laws of algebra.

select amount

from ...

Trey, it's possible they are relying on DBCC TIMEWARP to provide point-in-time recovery.

What is your ARID??

Sure... just test if it is evenly divisible by 1. The modulo operator (%) returns the remainder of a division operator, so if Amount % 1 = 0,...

Actually, the original query is a cross-tab. It just uses a CTE instead of a subquery. The Case statements in the CTE convert the rows...

Nabha, that looks like a winner to me.

It depends on whether or not it depends? :w00t:

I'm about to start through Itzik Ben-Gan's "T-SQL Querying".

If I run across an explanation, I'll let you know.

It's not a hack. It's just one more tool in the toolbox. If it significantly reduces the run time of a job, then it's a...