So you are asking us to invent lies for you? Sorry, but I won't do that and I doubt that Sue will either.

Have some professional integrity and tell the truth...

With that much experience, you should already have encountered plenty of relevant technical and organisational issues as part of your work. Go ahead and use those!

If I Google that error, there are a lot of hits. Have you tried following some of the suggested resolutions?

Here's a quick solution. There are more elegant ways of getting there, but I'm a little short of time.

DROP TABLE IF EXISTS #t1;

CREATE TABLE #t1
(
  ...

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...