ZZartin (4/14/2016)

---

Your order by isn't working because you are trying to sort by a alphanumeric field that doesn't sort in the order you want. Did you try this,

ORDER BY...

Both Drew and I have explained the problem. Please take the time...

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