i split my query into ~4K pieces and assigned each piece to a variable. Then i assigned them to one, and executed it.

SET @DynamicPivotQuery = @part1 + @part2 + @part3...

Your GamesWon definition gives these errors:

Msg 207, Level 16, State 1, Line 15

Invalid column name 'LeagueName'.

Msg 207, Level 16, State 1, Line 16

Invalid column name 'ShortName'.

Msg 207, Level 16, State...

Unfortunately I am not able to post data or DDL since it is proprietary. I just thought there might be a known problem with dynamic SQL and appending variables, such...

Exactly. Thank you.

The values are all hard-coded because that is the only way I can it to run for now. The point of the PIVOTS are to eventually replace the hard-coded values...

Same errors.

Without the variable it gives me the correct results.

http://citydynasty.com/Opponent/Baseball/MLB/2012-Opponent3.cshtml

The variable is "@ColumnName2".

I want to use it in the PIVOT statements so they can be run against any divisions without hard coding them as they are now (where you...

The errors I get when I use the variable are here. I don't get any errors when I remove the variable.

Msg 102, Level 15, State 1, Line 67

Incorrect syntax near...

Here is the SQL. If I replace the line 'SUM(ALWins) FOR Division_Name IN (['+@ColumnName2 +'])' with 'SUM(ALWins) FOR Division_Name IN ([East],[Central],[West])' it works correctly. The code is actually a...

I know it is being truncated because I get a syntax error at a point about a third of the way in my SQL which I don't get if I...

I think I have it working now:

WITH GamesWon AS(

SELECT Lge,

GameDate,

HomeTeam...

I created this query:

WITH GamesWon AS(

SELECT Lge,

GameDate,

HomeTeam Team,

...

The results from your query are:

Lge Team TotalwinsGamesBehind

LeagueATeamB4.0 ...

Thank you for your reply.

Your query works but it only uses wins for the calculation.

In this example:

WLGB

B410

A253

The "games behind" are found by subtracting Team A wins from Team B plus...