Thank you Jeffrey and Phil,

This is even better (was already happy with the solution), but this is even more elegant,

Thanks,

Ben

Similar result (see remark)

INSERT #SomeData (LongString)
VALUES
('dlfkjh zlghz lhzg ljshfgv ljhg "IsFso":truezxvlkzçfbhkjzçfbhxçdbjhzxddçjbkh')
,('dlfkjh zlghz lhckljshdf sdjkfsdfhgsdjkdhfgsdjhfgzg ljshfgv ljhg "IsFso":falsezxvlkzçfbhkjzçfbhxçdbjhzxddçjbkh')
,('nothing to be found here');


select *, 'true' IsFso from #SomeData where...

Thanks,

Passed this information on to the team.

We just made a connection to the database, with some struggles. But succeeded. Next problem. Although the table names were the same the default...

Thanks Scott,

This is what I was looking for. Remembered that something like this was possible. But it had escaped from my memory bank How to do it.  (Trying all different...

Thanks,

After puzzling a bit (a lot realy), and trying some construction, during a coffee break I decided that :In these modern times, there is often a solution on line, so...

• This reply was modified 3 years, 9 months ago by  ben.brugman.
• This reply was modified 3 years, 9 months ago by  ben.brugman.

Well no, but there were no parameters in your script, nor was it provided as a Procedure; I wouldn't have recommended it as a "fix" if that were the...

• This reply was modified 3 years, 10 months ago by  ben.brugman.

Perhaps a synonym would work for you here.

Why do the created tables have to have the same name?  Presumably it's because some common code needs to run against the...

-- EXEC SP_DROP XXX        -- For older versions of SQLserver
DROP TABLE IF EXISTS XXX
select top 11 * INTO XXX from...

• This reply was modified 3 years, 10 months ago by  ben.brugman.

I like...

Jeffrey and ratbak, thanks for your pointers.

Sorry for this late response. The question came up because of a wish and not a hard requirement. And something came up with a...

Thank you DesNorton,

It goes beyond Fuzzy Matches. It is not only 'single' fields like name address etc. which have to be compared, but complete 'free texts', it's a kind of...

Thanks this link does help quite a lot.

Especially with 'realising' that if there is not update timestamp of any kind this will not be possible. And second even with an...

Yes I did read that document, but fast, most of the texts I have seen in other documents.

To my knowledge the capture and the datastorage is done on the instance...

• This reply was modified 4 years, 8 months ago by  ben.brugman. Reason: Clarification

Oops typo.

Change Data Capture. (Sorry 🙁  )

Ben

In general when using the cases of overlap, people tend to forget specific cases because there multiple overlap situations. In the above I am missing  for...

• This reply was modified 4 years, 9 months ago by  ben.brugman. Reason: Again the formatting is not briliant, sorry for that