Luis Cazares (1/29/2015)

---

Maybe something like this. If you change/remove the third parameter of round() you'll get different results. This will always return the first payment equal or greater than all...

Scott Coleman (1/29/2015)

---

Louis's code puts the entire remainder in the first payment, which is technically what you asked for. Another approach would be to add 0.01 per month to...

First thought is that is going to work...Still have to run through some examples but this is looking like the way to go! Thanks Luis

I was happy as I thought this was going to work as it worked for most of my...

Thank you both for the responses, let me try them out and see what I come up with!

Also remember the amounts can change as well what it is divided by...

No I did not...We ended up ditching the replication process and created a backup/restore job!

Thank you for your responses! I will look into these and see if they help me!

Its a one time thing now, but its possible there will be a need for later...

That is the most common example...

The request I got was to compare two addresses and...

I know right...I looked in my email and saw where somebody posted a new comment...Then I clicked on the link and realized...

Thank you...

I looked in the distribution.dbo.MSrepl_errors table...

The first error is this:

Message: Failed to read column data Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper) at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String...

After doing some more diggin, I stumbled across this:

http://go4answers.webhost4life.com/Example/error-8152-during-snapshot-creation-73067.aspx

This is saying it has something to do with permissions...

I am using the SQL Server Agent account to do this...And...

HowardW (6/18/2013)

---

The Dixie Flatline (6/18/2013)

---

You can do the conversions on the fly in a single query by using expressions in your joins and where clauses. It may...

That was it...Thank you very much!

So is there not a trigger that will allow the transaction to happen and once it completes, a trigger will fire off?