You and Jeff have answerred my original question Ron. The T-SQL works fine if I make the decimal declaration static length and decimal places.

I wasn't sure if I should...

Thanks Ron and Jeff. Great solution 🙂

I tweaked it a bit to remove the '.' character as well as ensure the sign is counted towards the total length of the...

We are having issues with replication form 64bit 2005 to 2000 32bit.

So if we use 32bit 2005 on 64bit OS. There won't be any issues?

We are using merge replication with RDA over IIS. It is a bit slow. I was wondering if this is because we are doing replication via IIS instead of direct...

Thanks Jeremy and Steve.

I have a look into it.

We actually using SQL CE to capture the score from live Golf tournaments and using RDA to synchronize that to our SQL...