It was removed because it was a really bad idea...;)

Like I said, stop trying to decrypt the whole table... encrypt the lookup criteria and do a normal join or WHERE...

Why do you think you need the extra overhead of RTRIM/LTRIM when converting Decimal to Varchar?

Heh... why sure, Remi... just look at the difficulties Steve is having trying to fix some of the problems with this "forum in a can" code that RedGate bought. ...

Sure... somehow they managed to save trailing spaces in NVARCHAR columns... Use DATALENGTH to check... some of the columns are defined as 100 characters wide... and even if they only...

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.