Ok. Mostly data will be either from 2014 or 2015. so we can have where condition which just includes these two years.

my production table also has data from 2012 only. These table are just for data analysis so we are just pulling data from 2012.

yes. typically my table has just data from 2012.

I am new here. Earlier posted way was told somewhere post, so i pasted like that. So below has improved format:

create table #cs

(

[Year] float,

[Week] float,

[Month] float,

[C#] float,

[Dept] nvarchar(255),

[Issue] nvarchar(255),

[Type] nvarchar(255),

[Dept...

Yes for all the data.

Data will be selected from the table itself but C1 and C2 will be different and those values will be as explained in attached excel file.

Thanks

Here is the updated table, inputs and result table (in attachment). In last column of result table, i have explained the reason for few specific rows. and in C1, C2...

tell me what confusion you have. I will start explaining in that terms.

Ok. So here are the better explanation (hope this will help)

i want a result table with below columns:

Week, Month, C1#,c2# Dept,Issue, Type, Dept age

where C1 is C# for perticular week,...

Here is the updated table:

create table #cs([Year] float,

[Week] float,

[Month] float,

...

Any help???

Below is the table and desired results:

[Week] float,

[Month] float,

[C#] float,

[Dept] nvarchar(255)

,[Issue] nvarchar(255), [Type] nvarchar(255), [Dept age] nvarchar(255))

--===== All Inserts into the IDENTITY column

INSERT INTO #cs

([Year], [ Week], [ Month], [C#],[Dept],[Issue],...

this is with more extra values where no data exist for w5, 2015 and only 2014, and 2013 exist in this condition C1 will be of 2014 and c2 will...

Sorry for confusion, while testing few of the conditions came in picture. here is the updated one:

create table #cs([Year] float,

[Week] float,

[Month] float,

[C#] float,

[Dept] nvarchar(255)

,[Issue] nvarchar(255), [Type] nvarchar(255), [Dept age] nvarchar(255))

--=====...

This is working but failing for specific conditions like where for a perticular week, if no data exist for a perticular category combination, then its assigning c1 as previous year...