Have you tried adding an ORDER BY to compare the results?

Why would you want to complicate things? Sure, you'll get less columns, but you'll need to make your code more confusing. A bit column will take just a bit of...

If it's as simple as that, I would say that you're not getting different results, you're...

Be sure to understand how it works and ask any questions...

You need to post the plan files, not just images. If you need to anonymize the names for privacy issues, you could use SentryOne Plan Explorer.

The pictures just don't reveal...

Now, that's different. For this you actually need to create rows and a tally table is extremely helpful for this.

Here's a function that uses a cteTally which has zero reads...

zouzou (12/13/2016)

---

Well I know I made the mistake but this the query please forginve me if I put a wrong letter somewhere will send you in a moment the...

That query won't run.

Cereal

We still need DDL for the tables and indexes.

There's no need to create more rows, just do the math and replicate numbers.

DECLARE @Sample TABLE(

AC char(1),

Week varchar(3),

...

bucketlist50 (12/12/2016)

---

Thanks, both of you were spot on. It was the problem with the counter not incrementing. After I replaced @Counter +1 with cte.c+1 in the recursive query, it worked...

How can this be possible?

If you only have 5 digits on the first 6 characters, then you shouldn't have a seventh character.

However, I understood your...

Tempo

Is the code page the same for source and destination? Is the ETL tool doing some kind of data conversion?