Mulitple Saarch Criteria using ONE Column

Question

Mulitple Saarch Criteria using ONE Column

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

Jeff Moden (2/15/2012)
🙂
I did say that I've tested this before. :hehe:

Ah, but where would I be if I didn't insist on writing test-scripts to test everything?

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jeff Moden SSC Guru Points: 1003907 More actions · Answer 2

Cadavre (2/16/2012)
Jeff Moden (2/15/2012)
🙂
I did say that I've tested this before. :hehe:
Ah, but where would I be if I didn't insist on writing test-scripts to test everything?

Absolutely correct. "A Developer must NOT guess... a Developer must KNOW!" Taking my (or anyone else's) word for it would be absolutely the wrong thing to do and, no, I'm not being sarcastic or ironic there at all. You DID answer your own question and that's the way it should be done.

As a side bar, I did finish part 1 of an article that uses the test table generation methods that you, me, and several other people here have come to love. It comes out on (IIRC) March 26th here on SSC.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)