Hello,

I need to process stock information by day, but the database stores the info per week, using a column for each day.

I've tryed using unpivot but I need to...

I think it's just a misleading error from SQL dump, can it be ?.

More info - Package works fine when running from Visual studio. Only on the server when ...

What does the All Executions report show?

How far can they get? Can they run reports too?

I thought that it was open only to authenticated users. Are you saying that unauthenticated users have access?

Your table design is not normalised.

How about using something like (UserId, QuestionNumber INT, Response CHAR(1))?

Then your query becomes easy. And increasing the number of questions in future does not require...

Here's a code sample which demonstrates the technique:

DECLARE @SomeText VARCHAR(50) = '1 2 3 4    5 blah blah';

SELECT @SomeText
     ...

Replace the spaces first, then read the first 5 characters of the replaced string ...

LEFT(REPLACE())

Only...

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.