So when the user said they wanted Merge Replication, there were really describing peer to peer. Derrick, Do you think that is a fair assumption? Since this is...

Derrick, so you are saying when you have 2 distributors, 2 publishers and 2 subscribers it's peer to peer?

I was told to setup merge replication. What the...

I watched the snap shot and peer to peer. Awesome videos. My hangup is knowing if I should have 2 distributors, 2 publications and 2 subscribers. One...

WaIIy, I looked at these videos and I don't see anything on Merge Replication. Do you see it?

Thanks. I was hoping for someone to help set me straight. I'm reading but I not getting it yet.

Yes, this is a good one. I was thinking about a script that based on the fragmentation of the index would pick if it should reorg it or rebuild...

Thanks Gail. I didn't realize that. I thought I read that an index reorg is considered one long transaction. I must be getting my index rebuild and...

Thank you. Yes, I guess that is an option. I remember seeing a script somewhere that identifies those indexes that meet the requirement for an index reorg and...

Hey there. Glad to hear from someone regarding my post. Yes, we decided to try microsofts JDBC driver. It still didn't work for us until we put...

Okay. Thanks again Daryl. Have a great day!

That was it! It's working. Awesome! :hehe:

You never did answer what the -1* did. I think what it is doing is multiplying trans_amount by -1 to make it...

Hey Daryl,

Glad you are here.

I'm not a SQL expert yet! 🙂

I ran our old sql with the change you suggested:

SELECT (ISNULL(v1.non_credit,0) - ISNULL(v2.credit,0)) from

(SELECT CONVERT(DECIMAL(10,2), sum((trans_amount/100.00)), 0)...

Daryl, I tried (SELECT CONVERT(smallmoney, sum((trans_amount)/100.00), 0), I received this error:

Msg 8115, Level 16, State 8, Line 1

Arithmetic overflow error converting varchar to data type numeric.

Then I tried...

Daryl, I hadn't tried it yet. I just ran my SQL and got the results when I also received a post from you. It was a timing thing....

Thanks Daryl

We tried this but it looks like it truncated or rounded down:

SELECT (ISNULL(v1.non_credit,0) - ISNULL(v2.credit,0)) from

(SELECT CONVERT(smallmoney, sum((trans_amount)/100), 0) non_credit from dbo.request

where (trans_amount IS...