well, first of all , you will fail if they are integers. If one will be 15 and the other 13 you'll get 28, which might also be the case...

Have a look at the DENSE_RANK function I used. All the rest is just a quick & dirty code sample. Please note that I haven't tested this but it should...

That's because the IN clause cannot compare more than one dimension in the array...

I adopted the script to table variable sso I can test it. Here's what you need:

declare @qtral...

Although I owe much of my com[puter life to mictosoft Access, I think it's a smart decision to move away from that.

You're either gonna deal with the CSV producer or...

It really depends on many parameters, but as a rule of thumb - check if you need to apply this fix in many views or procedures and if all solutions...

This article, right here on SSC, wil be most helpful:

Recursive Queries in SQL Server 2005

[/url]

If that's the way your tool reds CSV I suggest you find fome other tool, but as per your question, you may append dummy lines in the following way: Suppose...

Had I had the full data, maybe I cuold come up with something else, but all in all it looks OK..

One thing though: Wouldn't it be better if you added...

Happy to help.

Also, I'm thrilled to see some people still opting for bitwise operations. It is very powerful yet so underestimated.

You might wanna test Levenshtein Distance Algorithm for both strings.

Here's an implementation in TSQL:

Levenshtein Distance Algorithm: TSQL Implementation

You'll also need this function for it to work:

MinOf3[/url]

This alows you to display a simple, maybe default, empty selection in your combo, maybe to allow for "every option" or "ignore...

The general .dat file...

Hi Michelle

I really am happy to help but it's quite frustrating (for you, because you are the one who needs the code) when you don't post any DDL to help...

I didn't get what you need. Maybe I can try and help yuo solve your problem instead of solving your solution... 🙂

Could you please post some sample data and what...

Hi

Could you please elaborate a bit more on that?

What o you want to return (in terms of DATATYPE: int, bit, etc) and to whom (calling SP, execution result, as a...