I'm beginning to wonder if Celko knows that we can't see the posts he is writing? Nothing like getting an email saying he responded to a thread I am...

That is the same thing you posted earlier. Without the YEAR in the mix you aren't going to get the sort order the way you want...

sqlinterset (6/23/2015)

---

Actually ordering in ssms is being done through this way. But when i am pasting same query in excel pivot tables then this is giving data in normal order...

Does this help?

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], [C#], [Dept], [Issue], [Type], [Dept age])

SELECT 2015, 14,...

Is this question based on the output from here?

Simple answer, no. Can you explain in greater detail what you are trying to accomplish?

Steve Jones - SSC Editor (6/23/2015)

---

This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.

Disclosure: I work...

Glad to hear you have the problem resolved. Forum etiquette would have you share the resolution so that others may benefit.

So, are we pulling hen's teeth again or are you going to actually help us help you rather than hope one of us makes a lucky shot in the dark??

Looks like you got your answer, but do you understand what the code is doing?

Remember, you are the one that will have to support it in production.

From the original intent we are far...

Just an FYI, with SQL Server 2008 and newer you don't need all those UNION ALLs.

N_Muller (6/22/2015)

---

I appreciate your comment, but you still didn't answer my question. Anyhow, there are many reasons you need a recursive CTE where maxrecursion > 100. A sequential...

Sean Lange (6/19/2015)

---

I...

meerack11 (6/19/2015)

---

I had try like if I enter new data like gl code CA700-40165_Home Dt Canada - Expedited Air' then its work but old data which already in table that...