Actually, the problem was that you can't upgrade SQL Server 2000 EE to SQL Server 2005 DE. We got it done though, just took a little extra work.

😎

After some research (didn't find anything), the only explanation I can come up with for this is that we thought we told setup to install the database engine, but must...

A) That is why I am trying to come up with a subset that is large enough to satisfy my testing. If after a few million rows of test...

Four years ago, my predecessors predecessor wrote 2 scaler UDF's, one to encrypt and one to decrypt a string using the same algorithm that the SIS system uses on-line. ...

See if this test code helps you.

create table #TestTable (

ActionVal int

);

insert into #TestTable (ActionVal)

select 1 union

select 2 union

select 3 union

select 4 union

select 5 union

select 6 union

select...

Does this number look about right: 2,758,547,353,515,625?

That's a heck of a lot of data to ensure that both functions are equivalent.

😎

LOL!! :w00t:

Thanks. Once I finish working on the second function, I'll start with your code and see what I can come up with. I appreciate the jump start!

Edit:...

We are still waiting for the OP to provide more information before doing anything. All we can do at the moment is shoot in the dark, and that may...

I can see GSquared's point, just don't seem to see another way to explain it at the moment. I'll keep thinking about it and if I come up with...

Just a guess, but ORLY = Oh, Really.

Like I said, just a guess. :w00t:

😎

GSquared (7/22/2008)

---

I think you may have misunderstood me. I have trouble with arrogance because I keep overshooting straight into hubris. (Yeah, I'll let you look that one up...

Actually, most of us have just asked for more from OP.

😎

Sounds good!

😎

Here is a sample, but be forwarned. the code below is not protected from a SQL Injection Attack. There are ways to write this to protect you, but...

tbeadle (7/21/2008)

---

If these data bases are on the same machine you might try something like this:

declare dnameStr varchar(30)

set dnameStr = 'ts2_' + @site + '_app'

select...