Actually, if you set the option in QA under "Tools - options - Results" to display as "Results to text", you could view the data....

I always use this option specially...

Guess the other lesson that you should add to this is to use Query Analyzer as much as possible...

select myTable.orderNum, myTable.LineNum, Qty, a.total
from myTable inner join
(select orderNum, sum(Qty) as total from myTable group by orderNum)a
on
myTable.ordernum = a.orderNum 

unless you want something like this..

select min(date) as date, employer from myTable

group by employer

?!?!?!

Sorry Ed - I've stared & stared at "Here is an example of how I want the result set to be ordered:" and still don't understand...

could you please explain again...maybe...

Maybe I am not understanding the requirements correctly, but ordering by employer & date should give you what you want...

could you please post the...

NOT funny when this happens but I just wanted to post the links to at least 3 different times in the past when this issue has been discussed..

missing posts...

wow indeed - 35 acres - & they say that "no man is an island"..

In the D.C metro area, land is at such a...

Henry,

Why don't you post the "select" that gets you your 500 rows as well as itemise the updates you want done...

However complicated it is, I am +ve that someone here...

You can edit directly in EM (as Paul) suggested but you'd be better off seeking help with your update statement and doing it in one fell swoop rather than manually...

sorry for asking what may be a stupid question - are you sure you meant columns and not rows... ?!?!

Another alternative to get all your rows is to store the...

raj - are you sure preethviraj's solution is the logic you want to use ?!

Also, what do you mean by wanting to add "another value"...is that an additional filter that'll...

It'd be much easier to provide a solution if you post your sproc...all depends on your parameter, query etc...for example, if your parameter is an ID, you could so something...

1) Pl. post some sample rows from your tables.

2) If you run with actual values, do you get the right results ?!

3) what is the application used to call the...

raj - this is all you have to do...

SELECT @Lesson = (store the result into a variable)

CASE

WHEN @param = Code_1 THEN Lesson_1

WHEN @param = Code_2 THEN Lesson_2

WHEN @param =...