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...

Right click on the table in the Object Explorer Pane, select Open Table.

😎

Hard to tell from the question alone. Michael Earl is right, we need to know more from the OP before we can really answer the question.

😎

Here is what I found in BOL.

G. Moving tempdb to a new location

The following example moves tempdb from its current location on the disk to another disk location. Because tempdb...

The easiest system database to move is tempdb. If memory serves me, there is actually an example in BOL on how to move tempdb. It does require a...