Yeah I know, but it took me literally under 1 minute to convert his table2 post into real code that I could work with. The arrogance...

Okay, gang, I'm trying a new approach to lazy posters. Experiment #1 is found here.

Steve, if you would prefer I didn't go forward with this...

I feel compelled to chide you a bit If you know it wasn't the correct format to post in, why didn't you do it the right way?...

Could you please supply a few rows of sample data for each table, and the expected results. It would allow the people trying to help you to test...

I obviously missed out on SO much by being born too soon.

Ph'nglui mglw'nafh C'thulhu R'lyeh wgah'nagl fhtagn

What kind of roleplaying game involves conspiracies, Gail?

fnord

No need to be so formal. Y'all can call me for short.

Thanks, Lynn, and hi everybody. Forgive the odd name. It's a personal quirk that when I'm feeling somewhat uncertain and tentative, I derive to a...

In the stored proc, I check for the following matches.

firstname = search text or lastname = search text or (firstname+lastname = searchtext) or (lastname+firstname = searchtext).

I did not notice performance...

Another potential solution is to have a stored procedure on the linked server which accepts a number of accounts and returns the results just for those accounts. The stored...

This will get it done. It looks clunky, but it runs fast. You can build it into a user_defined function or CROSS APPLY it to the...

Upon re-reading, I see that you have the user entering a single search string. I think it would be better to have them enter a first name and...

I have a concern from looking at your "trivial" example. If your user enters both a first name of "John" and a last name of "Smith", the...

Could you please provide a few rows of sample data, and what you would expect the output to look like based on that sample data?

Questions:

Is the start date you entered considered to be day 1 of week 1? In other words, if you enter a start date which is a Wednesday,...