You have a construction like this

INSERT ...

SELECT ... FROM

(INSERT ...

SELECT ...

)

INSERT SELECT does not return a result set, so your outer INSERT...

Kazmerelda (4/14/2016)

---

Had a brainwave as this will be an SSRS report I could do conditional sorting on it in there versus in the query itself.

Although I am a dog with...

Jeffery Williams (4/14/2016)

---

P.S. I tried an insert in the sample below but is says I need a FOR OUTPUT and this is where I am stuck, don't know where...

Jeffery Williams (4/14/2016)

---

If someone could help that would be great. I have this script that thrown the results to the screen but I need to insert the results into a...

ZZartin (4/14/2016)

---

You can put a case statement in the order by, so something like for the order by.

ORDER BY

case when [No Of Applications] = '1' then 1

when [No Of...

Why not just order by Number of Applications? Should have the same net effect.

Note that your range names are misleading and overlapping. '06-10' should be '06-09', '10-20' should be '10-19'...

Use a product that works properly, instead? :w00t:

Sorry, couldn't resist.

I was assuming that the requirement was for some sort of printed report, not just for ways of copying all or part of the screen as an image. But perhaps...

Nikku (4/13/2016)

---

Hi Phil,

Cell A Cell B Cell C Cell...

Sergiy (4/13/2016)

---

Are you sure those are actually question marks?

Those might be characters not from your default code page.

Because you import some sort of unicode strings into varchar columns those characters...

In SQL Agent, edit the job step.

Click on the Configuration tab and then the Advanced tab. Check that the '32-bit runtime' check box is selected.

pvong (4/13/2016)

---

I have a problem where an SSIS import will give me some ? characters in my varchar column. I want to run an update command where it will...

Ordering the output by the IDENTITY column makes this a challenge, as I am sure you are aware.

What is the difference between the first batch of NULLs and the second...

uzn2010 (4/13/2016)

---

I observed this second error in Execution task

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB...

richardmgreen1 (4/13/2016)

---

The files contain different data (and headers) and are loaded via a BCP routine.

The targets are also dealt with in a similar fashion (the target SQL table is starts...