Teaching how to fish... 😉

Heh... yeah... that'll work if you know the DBID... won't help you find the DBID for...

Ninja's_RGR'us (9/29/2007)

---

Just one question on that Jeff. How do you track the information of When, what, who inserted the original row?

I know this data should be kept separate from...

Well, I'll be damned... Now I know who to blame... 😀 (NOT Phil... Pop Rivet!)

I've had a bit...

Hi Bob...

Just confirming... how many rows does the following update?

4) The _Change fields would be the difference between the day before and the current day for the specific type. This...

In that article, the part that would work for a view looks like this...

SELECT emp_id, lname, fname, job_id,

(SELECT COUNT(*) FROM employee e2 WHERE e2.emp_id <= e.emp_id AND e2.job_id =...

Don't know much about that in 2k5 and I usually don't use DTS in 2k.

One of the "problems" (and, advantages) of RDBMS's, is that...

Webrunner...

Gail has it right.

I'm always curious about deletes though... why are you deleting instead of just "end dating" or deactivating? Seems like you're losing some history...

You mean the same ones that RPAD in SysProcesses? 😀

Why don't you just make a linked server betweeen the two environments and do the insert from the linked server?

Don't try to decrypt the whole table... encrypt the data you're searching for instead. Don't forget to add an index.

Cool... but it's customary to thank folks by posting the code that you used to make it work 😉

Heh... how quickly you all forget... there were TWO of the bloody damned things 😛

C'mon... you know better than to make us ask you for the table/column schema... it looks like your dates are Integer based, but who can tell??? :blink: And,...

What are you using to do the actual export?