This is the sort of thing:

DROP TABLE IF EXISTS #User;
DROP TABLE IF EXISTS #Language;
DROP TABLE IF EXISTS #UserLanguage;

CREATE TABLE #User
(
    UserId INT NOT NULL...

Your first 'query' is actually 10 separate queries producing 10 discrete result sets.

Assuming you're just going to UNION ALL the first query, this is still impossible to solve without adding...

Do you even have SQL Server installed somewhere?

Because your code does not run. Even your modified code is riddled with errors. Here's a sample:

1. CREATE TABLE statements do not end...

Note to OP: please try running your own query. And then, please fix it so that it works 🙂

To pass this info back to an app near the client, are you going to send a string list of language names?  Ugh, that seems worse to me, I'd...

Good start, but your query does not parse and you have not provided your desired results.

It is certainly possible, though it is likely you would have to install things on your server which should not really be there (the Microsoft Excel application).

Once you do that,...

Hi Rechana,

Your question is interesting to me even though unfortunately I don't have any expertise to share with you. but I subscribed to see what you end up choosing...

Drew,

I feel like such an idiot. You're absolutely right about the parentheses. That solved problem #1.

I knew the text data type was deprecated but never thought to CONVERT or...

This is not a pleasant one to solve.

The only way I know of doing this is to write some C# code in a script task which will get the sheet...

May I ask what you are trying to achieve overall?

You mean if the INSERT fails? Yes, you can redirect...

The validation your are referring to has to be done manually, ie, create some queries which identify the issues you are concerned about and run them on the staged data.

If...

Secondly, do you realise that your table thoroughly violates relational database principles?

A Gender table should contain, erm, genders and only genders.

A City table would contain your cities.

A Person/Customer table would...

First of all, there is no need to shout ... please consider using some lowercase letter in future.

Secondly, please provide your data in a consumable format (one which can be...