This query is probably pretty simple once we know what it is supposed to do. The biggest problem here is that you don't have a well defined question. Without a...

sqlinterset (6/19/2015)

---

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,...

lmarkum (6/19/2015)

---

I have an UPDATE statement that joins two table by SendId. One table, I'll call it T1, has a clustered index on SendId ASC. The other table...

ChrisM@Work (6/19/2015)

---

I'm with Alvin on this one Sean - walk away. The...

Lynn Pettis (6/19/2015)

---

Sean Lange (6/19/2015)

---

Alvin Ramard (6/19/2015)

---

I think this is one of...

Alvin Ramard (6/19/2015)

---

I think this is one of those threads where one...

Nothing about your expected results makes sense to me at this point. You have 12 rows in...

Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx

Taking your various posts I was able to piece together ddl and sample data.

create table #cs

(

[Year] float,

[Week] float,

[Month] float,

[C#] float,

[Dept] nvarchar(255),

[Issue] nvarchar(255),

[Type] nvarchar(255),

[Dept age] nvarchar(255)

)

INSERT INTO #cs

([Year], [Week], [Month],...

sqlinterset (6/19/2015)

---

Here is the updated table:

create table #cs([Year] float,

[Week] float,

[Month] float,

...

Nice attempt at posting ddl and sample data. Unfortunately the table definition is incomplete and the sample data won't run as posted.

Why in the world are you storing Year...

Ed Wagner (6/18/2015)

---

Eirikur Eiriksson (6/18/2015)

---

Sean Lange (6/18/2015)

---

Eirikur Eiriksson (6/18/2015)

---

Too busy to respond and I think it's time to introduce "crystal bullets" since the C-ball is a no show these days,...

Eirikur Eiriksson (6/18/2015)

---

Too busy to respond and I think it's time to introduce "crystal bullets" since the C-ball is a no show these days, any bullets, fragments or shrapnel should...

venkyzrocks (6/18/2015)

---

Hi all,

Need some help here,. See belwo :

Row Value :

Fiscal Year: 2016(

)Budget Scenario: Main Budget (0+12)(

)Forecast Scenario: Jun (0+12) Forecast(

)Department: 400 - New York(

)YTD Period: Jun

and I need to...

You...