Does this work?

UPDATE TBP

SET TBP.[Quantity_Remaining] = TBP.[Quantity_Remaining] - 1

FROM INSERTED I

INNER JOIN [tblTransactions] TT ON I.[Transaction_Number] = TT.[Transaction_Number]

INNER JOIN [tblBulkPurchases] TBP ON TT.[Transaction_Number] = TBP.[Transaction_Number]

WHERE TT.Transaction_Type = 'From Bulk...

Attached is a script that I have had around for a long time. I don't even remember where I found it, or who wrote it, so I can't even...

Well, it seems like a lot of extra work to capture this. Why is the looging available in SSIS not adequate?

And, xp_cmdshell is one of the features that fall...

The new posting is a lot cleaner.

From a purely personal perspective, when I see requirements like this:

• Experience working with Windows server, including Active Directory and proper disk configurations.

•...

I have been on a search for a new position for almost a year. I have landed my "dream" job as a senior DBA, though!

I actually saw this listing...

Can someone, anyone, get the Microsoft SQL team to talk to the Microsoft Dynamics Great Plains team?

Can you say database best practices?

No. I can stop/re-start, no problems.

The only time this appears is when we fail over to another node using Cluster Manager.

To add a bit more info, the nodes...

Look up exactly what DATEDIFF does in Books online.

Then, look at the values of the expiry_date field.

Are there values in this field that are greater than today? ...

To possibly go off track, when you say this is for the purposes of auditing, you do realize that maintaining this relationship defeats the purpose auditing?

For starters, the auditing system...

It seems too simple, so this may not be what you want:

SELECT TOP 10 ROW_NUMBER() OVER(ORDER BY columnA ASC) rn, columnB, columnC

FROM #tableA

There are 11 rows in your sample data....

No, you are joiing the table to itself. This is probably an easy (Argh!) query, but without DDL and sample data, it's a guessing game.

For starters, without any DDL and some sample data, we cant really give you a lot of help.

That being said, here are a few thigns to look at:

1. If you...

Bron Tamulis (1/20/2012)

---

Leo - Thanks for the reply.

I know DYNSA is not an orphaned user. DYNSA user is automatically created when Great Plains is installed on a SQL Server, much...

It sounds af if the subscription was never initialized.

To re-state what I think you need, or want:

1. Server A, Table A, 10 rows get inserted. These rows then get replicated to Server B.

2. Server B, same Table...