Cadavre, is there a reason on why you didn't leave the condition as it was?

Should we test the difference between yours and this?

UPDATE fi

SET fi.cor = 'Y', fi.tam =...

Did you read...

That's because it's giving your results by groups, not the total.

As you didn't post DDL or consumable sample data, here's an example that can help you to fix the query.

DECLARE...

I've seen it before, had to use it and hated it completely.

It was the worst database design I've ever seen.

It's pointless and will cause problems trying to understand what the...

I told you that was a start.

What you need is dynamic code to include all columns needed.

Have you read the articles?

I only found a problem with your query but it should throw an error and not incorrect results. The problem is the query is not complete.

Could you post DDL?

As a...

Have you read Jeff Moden's articles on cross tabs and Dynamic cross tabs? Search them in this site.

I don't remember if ROW_NUMBER is mentioned on the article, but this will...

I had the same idea, but I added an extra condition because your query will return results with no period...

I was so close, thanks to the QotD that made me remember the PARSENAME function.

My code

SELECT @HOLDER = ID

FROM #testEnvironment

WHERE PARSENAME( CAST(yourData AS NVARCHAR(MAX)),3) IS NULL

AND PARSENAME(CAST(yourData AS NVARCHAR(MAX)), 2)...

But you're assuming that an identity column is available and that it has no gaps.

You're assuming as well that the data is being inserted to the table in the correct...

To help...

You should do formatting on the front end.

But if you must do it here, an...

There's not much we can do without DDL and sample data.

To audit the problem, you could do a simple select instead of the update.

Another thing to watch is the datatype....

The Dixie Flatline (10/23/2012)

Agreed. One fix would be...

No, I was referring to his article on...