Your code is different from what I suggested. In particular, you changed <> to 'Like'.

SELECT ...
FROM sometables
WHERE t4.ReturnDate >= DATEADD (yy, -2, DATEADD (yy, DATEDIFF (yy, 0,...

These are the rows that did not import properly:

and here are the originals (taken from the CSV file)

So now you can see why they...

• This reply was modified 1 month, 2 weeks ago by  Phil Parkin.

I just tried this and it imported quite easily.

Assuming you're in SQL Server Management Studio and want to import the data into a new table in a database which already...

If the following query produces more than one result, that is your problem – you cannot update a single value to a multi-valued result set:

SELECT DISTINCT
 ...

Yes, that's a fair comment.

We've gone down a hybrid path, with most DBs migrated to Azure SQL DBs, but SQL Server VMs for those that are not supported or need...

Removal of results is done by including your condition in the WHERE clause, not in the SELECT.

WHERE custid not like '%abc%' or company <> 'abc'

SSL encryption is configured on the server/host. But imagine a scenario where SSL is not configured . How does it look if SSMS choose encryption as mandatory and checks...

I think you might be in trouble here, but will be interested to hear what other people think.

Are you in the process of migrating to Azure and had not considered...

I have a suggestion to help avoid this problem. Make step one of your process a file copy, to bring the Excel file to a local (to the server) drive....

@SQL_Bee, are you planning on posting back with an update on this thread?

hi phil, there is no error message, the wrong file ends in file stream directory and the trigger is somehow executed or not. i can see it only, because...

What is the exact text of the error you are receiving? How do you even know that there is an error, if you cannot see it or trap it?

I should also mention that a lot of the 'good stuff' in PBI requires a 'Premium Per User (PPU)' or 'Capacity' subscription. These cost more than the entry-level 'Professional' subscription,...

Is there any equivalent in PBI for data driven subscriptions?

How is scheduling of reports handled in PBI? One use case I have for example is: 1) create an unscheduled subscription;...

I do have a follow-up question. When I've encountered PBI before, I got the impression that it required a server component somewhere in order to run. Even your response...