ScottPletcher (11/30/2012)

---

...

Are you sure that hi __[blank] low is "more logical" than "hi lo __"?

What about a potential for 10 scores?

If you're reading it, do you want to see "hi...

ScottPletcher (11/30/2012)

---

...

In the interests of being thorough, I added a Message to my proposed solution back to them:

SELECT

...as above...,

CASE WHEN COUNT(*) >...

jasona.work (11/30/2012)

---

If our devs had used the patient ID value as the identity, it would have been a (10,10) seed. The way the current billing application handles patient IDs...

If you using flat-text-files for export-import of data, you should not allow data to contain the same control character (or combination of them) used as row or column separators.

As...

another one, for my logic only, without even CASE WHEN (actually it's hidden under NULLIF):

select student_id

,high_score = MAX(score) ...

I am not be surprised when good skilled T-SQLers come up with stupid answers on paper during interviews....

what do you mean by "mid-score"? Do you mean average or second largest score (from three possible ones)?

reposted

Looks a bit illogical to me...

I can see why mid_score should...

Shadab Shah (11/30/2012)

---

Chris Harshman (11/30/2012)

---

Have you looked at the execution plan of the query to see what part seems to be a bottleneck? It could be possible that an...

It's not an issue. It is default setting.

menu Tools/Options

expand Query Results/SQL Server

select Results to Text

change "maximum number of characters displayed..." to 8192 (that is absolute max to be displayed...

Can you give it to someone else to do? Surely if...

How many records does query return without parameters?

Looking the latest version of your sp, I can tell that it has quite few things...

1. Brackets in WHERE clause of your...

I have also noticed that your code is changes from post to post 😉

Now I can see that you also trying to page it.

Please note:

SET ROWCOUNT is not the...

freecoder (11/30/2012)

---

ok I tried your query and the result has not change at all. I change the responsibilitycode parameter to a specific one instead of 'ALL' the query works fine...