The DBA aspects of it are standard. Nothing particularly new or different. After all, backups and index maintenance are backups and index maintenance, and quality T-SQL is quality...

You'll need to write down all the rules for joining the tables. Otherwise, I'm left guessing.

The terminology is the thing that'll kill you faster than anything else. Some of it will be industry terms, some will be local dialect. You'll need to get...

It looks like a simple join using the ChildID will do this.

select TA.DropID, TB.DropID, sum(Qty)

from TableA

inner join TableB

on TableA.ChildID = TableB.CaseID

group by TA.DropID, TB.DropID;

I'm assuming that you want...

You're welcome.

Steve Jones - SSC Editor (2/23/2011)

---

GSquared (2/22/2011)

---

What I was asking was: Did Steve mean the question to be about legitimately protecting code, or did he mean to ask about people...

The only way to avoid that will be to put the SSIS engine and package on one of the two servers. Any method that involves a third server will...

If you're looking for columns and rows, you can use FOR XML to format it into an HTML table. Microsoft has an example of that on MSDN if you...

bitbucket-25253 (2/23/2011)

---

GSquared (2/23/2011)

---

Brandie Tarvin (2/23/2011)

---

WayneS (2/23/2011)

---

Brandie Tarvin (2/23/2011)

---

LutzM (2/22/2011)

---

Jeff Moden (2/21/2011)

---

...

I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da...

If the data is going from one server to another (A to B), then the data also exists for some period of finite time, on any routers/switches in between them,...

You're welcome.

Try something like this:

ALTER TRIGGER [dbo].[Update2ndTable] ON [dbo].[Table1]

AFTER INSERT, UPDATE

AS

SET NOCOUNT ON ; -- Can be very important in triggers

...

I always set up (or get set up) a domain account that's specifically configured for running these jobs. Minimum permissions needed, and definitely not my own account if I...

Edit to remove double-posting. (Connection issue.)

I've actually been meaning to write an article on that.

To...