You got help here... help us, please.... what is the business rule that you've been made to suffer that requires all parts of a...

There's no special technique for this... it's simply the choice to figure it out using regular ol' set based code. It doesn't require a Tally table or any of...

Heh... you mean the pork chops go to Kamran Ali. 😛

If someone would post the "example data" in a reasonable format according to the link in my signature below, maybe...

Sounds like a fun binary search problem... I'll have to give it a try using pseudo cursors. Thanks, Alexander... I'll dog-ear this post and let you know what I...

mverma4you (3/2/2009)

---

you are not allowed to use the RAND() function inside UDF function. To call the value of this function create a view with the single statement select RAND()

And then...

Does the real #PointPartners have only 3 columns you want to join on? If not, how many?

This should be done with a UNION ALL rather than going...

Buy some 3/8" aquarium tubing, instead.

There is no need for the RBAR of a function to generate random integer values. The only reason you think so is because you found out that RAND returns...

See the following articles... the first one explains some of the performance problems with using PIVOT instead of building good ol' fashioned cross-tabs and the second one explains one method...

I'm with Gail... WHY do you want to do this to a perfectly good database? What are the business reasons for this?

Your IF statements are fine and they don't require the use of dynamic SQL.

My big question would be... why do you have separate tables for all that stuff?

Why would you need to loop to do effective mortgage rates?

Heh... I've not been as active on this forum in the last 2 weeks as I normally am... ya...

Thanks, Lowell... that's an awesome compliment. They'd probably just make the same excuses as everyone else, though... things like "it's good enough for what we want to do" or...

alexander.yuryshev (3/1/2009)

---

Jeff Moden (3/1/2009)

---

Heh... and IMHO, CLR's have virtually no place including UDF's. RegEx and file handling are the only two places I've not been able to beat a...