Please check this post for an example of how you need to post your question in order to get a working solution in response.

Without sample data, I can't provide a solution.

But I can suggest an approach. Build a subquery which selects only those rows which satisfy your criteria and then

INSERT...

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