Actually I think that Kumar's case function might have the "1" and "2" backwards.

Like this:

Select F1, F2

From TABLE1 t1

Where EXISTS(Select * From TABLE2 t2

Where t1.F1 Between t2.F1 and t2.F2

And t1.F2 Between t2.F1 and t2.F2)

andrewd.smith (2/19/2009)

---

This is the line causing the error:

select @result = ((1+@lf_group1/100)^(12/@lf_exponent)-1)*100

The ^ character represents the XOR operator in TSQL, not the exponential operator that it represents in VB. In TSQL,...

And how are rows to be joined between the two tables? Do you want every row from Table1 that has any overlap to any row from Table2? Or is...

Yes, but will have to define what you mean by match. Do you mean that the first range is completely contained by the second or do you mean that...

You know, I've been so busy the last month or so, I missed this when it first came out. This is an impressive piece of work, Lynn, congratulations. ...

Yeah, the search facility is really awful. I cannot imagine how it hard it is for you, Jeff, with 3 to 5 times as many posts as me!

Example: use...

One thing that I would really like to see, is better capabilities for managing, organizing or even just finding forum posts, even just our own previous posts. Great as...

GilaMonster (2/21/2009)

---

After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating...

Hey, Eron The Relentless, I haven't seem him in a long time!

Nah, I was playing a White-Blue Wrath of God/Blinking Spirit with counters deck. It was OK for the time (very weird format) but is was too slow.

Glad we could help and thanks for getting back to us.

Bob Hovious (2/20/2009)

---

Even worse 🙁

I graduated high school in 74. I played...

Lynn Pettis (2/20/2009)

---

Alvin Ramard (2/20/2009)

---

Is...

I believe that you will have to migrate your package from SQL 2000 to at least SQL2005 before it will work.