Viewing 15 posts - 301 through 315 (of 4,080 total)
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 -...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2016 at 6:49 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 10:12 pm
PLEASE DO NOT POST A SINGLE QUESTION IN MULTIPLE FORUMS ANY MORE.
MOST OF US CHECK THROUGH ALL OF THE FORUMS.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 7:04 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 4:55 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 3:23 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 11:45 am
I certainly don't require an apology. Glad it works for you. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 11:37 am
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....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 9:55 am
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,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 8:33 am
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?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 8:12 am
Also, please define what you mean by "closest". Closest to what? The start point of your range, the end point of your range, the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 8:01 am
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,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2016 at 7:57 am
The code above was modified to remove an excess payment row.
And to change the final presentation order.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2016 at 2:01 pm
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')
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2016 at 1:48 pm
Looks like you've already asked elsewhere, but your query brings to mind some questions.
UPDATE T
SET SALE = SUM(Sale),
Exp = SUM(EXP)
FROM Sale T
INNER JOIN Exp S ON (T.Area = S.Area)
WHERE ordertype...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2016 at 8:45 am
Viewing 15 posts - 301 through 315 (of 4,080 total)