The problem is that you're comparing the same column and same row expecting it to have different values.

What you need is a self join. Something like this:

select GLAccum.Endbal, GLAccum.Base, GLAccum.Division,...

You're welcome.

Next time, avoid posting lengthy procedures and post only the ones relative to the errors. If you double click on the error, it will locate it for you. You...

Considering the ACCTPERIOD has a value of 16456874

Which would be the correct result?

164412 (first four digits minus one with a two digit suffix of 12)

16440012 (first four digits...

And what's the problem of the current query other than not being SARGable?

Try to avoid functions on columns in the WHERE clause. The condition can be changed like this:

SELECT *...

Based on your sample data, what are your expected results?

These articles might help you:

Generating Test Data: Part 1 - Generating Random Integers and Floats[/url]

Generating Test Data: Part 2 - Generating Sequential and Random Dates[/url]

The reason for getting errors on queries like

select * from table WHERE ISNUMERIC(LTRIM(RTRIM(Capacity))) = 1 AND Capacity < 0

Is that SQL is a declarative language, so even if you write...

Basically, you need to change the columns in the group by in this update

update [tempdb..##Performance_SUM_Detail_Data_table] set Produced = (select sum(Producd)

from X_Produced_By_Period where

B2BNR = bu AND B2PLT = PLT AND B2BBE...

You say Disaster Recovery but you only mention High Availability solutions.

What do you really need?

This.

If you can see the leading zeros in the file using notepad or something similar, that might be an excel problem. Be sure to define that column as string when...

This is either a permissions problem because the service account doesn't have permissions to access the path or the path might not exist. Remember that local paths refer to the...

That's because you're returning 2 values to assign a single scalar value.

Here's a refactored version of your query to avoid an additional hit on the table.

select DISTINCT

...

That's because the code stopped and never dropped the temp table.

Drop it before running the code again. Even better would be to have something like this before creating the table:

IF...

Foxboro? Ok, that's not a bad word, I just dislike the NFL team that plays there.