Thanks Steve. Just wanted to geocode a bunch of addresses in my database.

Not 100% sure this works... but it should at least give you some ideas... If you use LAG(), you can get the "previous" record (in time order) and see if...

If you're trying to do an exact match, it's just:

WHERE [ColumnName] = 'LifeCare Amb MH'

Starts with and ends with is easy:

WHERE [ColumnName] LIKE 'LifeCare Amb MH%'

WHERE [ColumnName] LIKE '%LifeCare Amb...

Are you searching for an exact match or just records that contain "LifeCare Amb MH"?

Since you didn't provide any consumable data, it's hard(er) to figure out what the problem is....

Without CREATE TABLE and CREATE INDEX scripts and the actual execution plan, there's not much anybody here will be able to suggest, I don't think.

Did you not see Steve Collins' answer?

What's the point of reposting the question verbatim in as different thread?

sys.all_objects will give you tables and views, and sys.all_columns will give you column names and type info etc.

• This reply was modified 4 years, 10 months ago by pietlinden.

Okay this is confusing. You're using both a windowing function and GROUP BY.  I don't think that's right. If all you're doing is looking for duplicates, the simple pattern is...

well, when I ran the CREATE TABLE and INSERT scripts, nothing happened, so I couldn't reproduce the problem.

There are tons of people here more knowledgeable about indexing than I on here, but a couple things spring immediately to mind:

Are you doing something really nuts like SHRINKDB() all...

I did it a different way than Brian did...  the SELECT queries are always nice to make sure you're affecting only the records you intend to... (better safe than sorry!)

I think this works... <g> Oh right... the DATEADD stuff is just to confirm that it's actually a date at that point. It is. <g>

use tempdb;
go

DECLARE @FileString...

• This reply was modified 4 years, 10 months ago by pietlinden.
• This reply was modified 4 years, 10 months ago by pietlinden. Reason: me mordio la estupidez!

Following on from what Steve suggested, if all the Excel files have the same structure, you can use a folder source in PowerBI (or Excel) and it will append all...

Why not model like a regular invoice/invoice detail ? You're making this way harder than it has to be.

Once you understand how normalization works and how to apply it, this...

SELECT TOP (n) ID

FROM MyTable

ORDER BY NewID()

then build the insert from that. ORDER BY NEWID()