Please use IFCode tags in future. It makes things very much easier to read.

SELECT t.mes

,...

What is the logic behind your desired ordering?

Eirikur Eiriksson (5/11/2016)

---

Sean Lange (5/11/2016)

---

WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual thread when...

I can't believe that this thread is still going strong. Had you taken the time to provide source data, DDL and expected results, as described in the...

Thom A (5/11/2016)

---

Will the columns always be the same amount, for example Columns A through to J? If so, you can set the sheet name to;

[Sheet1$A2:J] This will make SSIS...

anjaliagarwal5 (5/10/2016)

---

Hi All,

I am passing a parameter as @col1. I need to set col3 to 100 if @col1 =1 else col3 will be any value that is passed in....

Not sure exactly which line is causing the error, but I expect that adding WITH RESULT SETS will fix it.

OK. What do you need help with? Which technology to use? How to create a table? How to write an INSERT query?

Maybe something in this link[/url] will be of use.

Occam's razor clearly does not apply in this case. Instead, perhaps, there has been a great disturbance...

OK....

Is there any reason why you would not use a simple data source to do this?

And why use a script component rather than a data transformation?

MaPar (5/9/2016)

---

Hi,

I've recently started a new job and have found cursors to exist pretty much everywhere. I'm trying to replace these to use set based T-SQl but I'm struggling...

Ok, we know your requirement. Now what is your question?

rk1980factor (5/5/2016)

---

Just to clarify little bit more:

1) i want to display all the records

2) but I want create new column says School which has data from either district or area....