Code to create a working version of this technique…
So here’s the implementation for part 2 in a web project. There are a few caveats to this thing. First off, for demonstration purposes only m-kay? Don’t go trying to put something like this into your production environment, please. Second, it does not have a great deal of logic as far as randomization goes for search results, so I’ll leave some of that fun for you to work on. (And when you come up with something cool, please forward to me so I can check it out). Finally, it dumps all results that match at least 33% to the data grid, something that you would probably not do in your search. Anyway, download the zip file which includes the project, below, and get the TVF from the link below. There is a Readme.txt located in the project. As always, RTFM, please.
If you need any assistance putting this together, give me a shout.
Lee
------------------------------------------
Whassat you say? Bitmasking, part 3? Look for it to come out around 2012.
Table-valued function - http://www.sqlservercentral.com/articles/bitmasking/66774
c# web project – ASP.NET Web in c#
7b1e1dc1-b27e-48de-997a-a778739e2d4a|0|.0