RE: Comparing string with date

SSC Guru

Points: 1003875

January 29, 2014 at 9:55 am

ChrisM@Work (1/29/2014)
Jeff Moden (1/29/2014)
Post deleted. I made a mistake. I'll be back.
A little history Jeff. Might save you some time.

You're right. That's insane and now I know what you meant in your original post. The OP changes perfectly good data to denormalized data and then tries to do a search on the denormalized data. I just don't get that and your original suggestion on this post is correct.

Too bad because I finally learned how to copy'n'paste my SARGable solution correctly. :blush:

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