Try this

Declare @cols nvarchar(Max);

Declare @query nvarchar(Max);

Declare @tier tinyint;

Set @cols = 
STUFF
(
(select ',' +  Quotename(a.lbl)
from
(
select distinct DATEADD(DAY, -DAY(timestamp)+1, timestamp) ord
, 'Tier 1 GB - '+ cast(DATENAME(month,timestamp) as...

Here is a solution. You would need to adapt it as you have more instances of each ID, but it should be pretty straightforward to change. Otherwise you can use...

• This reply was modified 5 years, 7 months ago by  femi.olaniyan. Reason: tried to change the formatting

Try...

if OBJECT_ID('tempdb..#temp') is not null drop table #temp;

if OBJECT_ID('tempdb..#cte') is not null drop table #cte;

create table #temp
(
[unique_id] varchar(50) primary...

Try this:

select a.ID
,b.*
from
#TEMP a

left join #TEMP1 b on
b.ID = a.ID
and b.Letter_Type = 'C'

Try using pivot

select p.Partitionkey
,p.Account
,p.JDEacct
,p.Entity
,p.Entityx
,p.Udx1
,p.Rule_ID
,January,    February,    March,    April,    May,    June,    July,    August,    September,    October,    November,    December

from
(
select a.partitionkey, a.Account,a.JDEacct ,a....

If there can be potentially more items you need to use a dynamic pivot:
if OBJECT_ID('tempDb.dbo.#temp') is not null drop table #temp;

create table #temp
(
 ...

If at most 4 items you can use this:

if OBJECT_ID('tempDb.dbo.#TestTable') is not null drop table #TestTable;

CREATE TABLE [dbo].[#TestTable] (
[PhaseId] [int] NOT NULL,

Hmm..What happens when you remove the Order By clause within the Over clause?
SpikeVal/cast(count(a.Flag) over(partition by a.Fid, a.AccountNum, a.Flag , b.readDate) AS decimal(6,4))

if you are getting an error message, can you post it?

Declare @TableA as table
(
FID numeric(8,0),
AccountNum char(9),
Spike_Reading_Day date,
SpikeVal int,
Flag char(1)
);
Try this...

Declare @TableB as table
(
FID numeric(8,0),