+1 Eirikur

I wouldn't have thought that would have worked. From somewhere I had the idea that time datatypes always "assumed" day 0. (Our systems always...

Sergiy, I too have been working with fuzzy matching on peoples' names for over a decade. I hear what you're saying, but that remains a manual process -...

Sergiy, the problem with that approach is that it works for synonyms but not for typos in the correct character string. For example:

ABC Movres

A.B.C Movers

Authentic British Cars Movers

Authentic...

PLEASE DO NOT POST A SINGLE QUESTION IN MULTIPLE FORUMS ANY MORE.

MOST OF US CHECK THROUGH ALL OF THE FORUMS.

I've got a better function than SOUNDEX for you. It's called "StringsClose" and it compares strings while forgiving one and only one typo. A typo...

I don't believe you are taking the date into consideration.

Midnight (00:00) is treated as the start of the day.

If the 19:00 time is...

If I understand you correctly, I regret to tell you it can't be done in the same fashion as your Excel spreadsheet without some complicated Dynamic SQL which would not...

I certainly don't require an apology. Glad it works for you. 🙂

Then I urge you again to store them in two columns of your resultset rather than one, otherwise you will have to split them out to work on them again....

I think this is what you want, but with the data supplied, the code below is producing slightly different results.

Get used to using APPLY for subqueries,...

Are you ever going to have to work with those values from the result set again? Or is displaying them the end of their usefulness?

Also, please define what you mean by "closest". Closest to what? The start point of your range, the end point of your range, the...

SQL doesn't work like EXCEL, where a cell has two lines in it. SQL only stores values. If you want to preserve both values,...

The code above was modified to remove an excess payment row.

And to change the final presentation order.

Have a look at this.

declare @sample table (Custno int, RowID int identity(1000,-1), RowType char(1))

insert into @sample (custno, rowtype)

select top 100 N, RowType

from vTally

cross apply (values ('P')

...