Thom beat me to it!

microsoft.com vs amis.nl ... I know which source I'm going with.

Jeff, thank you for taking the time to write all of this stuff out.

Importing from Excel using SSIS is almost always a massive pain, so I am going to check...

No it isn't, it's a Window function.

John already provided a link to analytic functions. Had you followed it, you would have seen that DENSE_RANK()...

Another possibility is extracting a DACPAC for the DB in question and building an empty one from that.

OK, so what was the "silly" fix you employed?

I'll also state that it's a shame that you're...

If the procs don't contain DML, what do they contain?

Presumably because NULL is not a value.

Have you considered just using ELSE?

Otherwise, use the extended 'Searched CASE' syntax:

... WHEN Education is NULL THEN 'Unknown'

I do this in (a significant chunk of) C#, using a Script Task, for .XLSX files (as well as CSV files and Access files).

It's not for beginners, but it's not...

If you want a working solution, please provide your sample data in the form of CREATE TABLE/INSERT statements.

Please expand on this:

But when i open and saving that same excel file as .xlsx format it loads without error.

What format was the file in before you opened and saved?

That is a requirement, but what is your question?

1. How do I restore a database?
2. How do I restore a database when the name of the backup is dynamic?
3. How...

• This reply was modified 6 years, 6 months ago by Phil Parkin.

If you want a working query, please provide DDL, sample data (in the form of INSERT statements) and desired results (based on your sample data).

You'll probably have to provide a...

I'd still lean towards looking to buy some other CRM tool versus build your own.

Based on what you've (the OP) posted so far, I'd agree with this. I used to...

Is the scope of this work as follows?

1. Build a SQL Server database which matches your existing database
2. Migrate existing data to new database
3. Replicate existing Zoho CRM application functionality

...

SELECT o1.*
FROM OrderItem o1
WHERE NOT EXISTS (SELECT 1 FROM OrderItem o2 where o1.OrderId = o2.OrderId and o2.Status <> 'Shipped')