appologies all - I should have looked up my code last night rather than try to remember...

here is the order by clause for an address table that does work

ORDER BY

case...

there is another way... (there always is)

and something to think of - what happens if you want you criteria to change?

use parameters to make your criteria more global - and...

there is another way... (there always is)

and something to think of - what happens if you want you criteria to change?

use parameters to make your criteria more global

DECLARE

@category varchar(20),

@specname1...

I take it the task names you have given (and are reporting) are a subset of all of the available ones.

Hence the IN clause in the query.

It might be better...

Orblin McLoon (7/1/2008)

---

Thanks Carl!! That code worked great.

What about having another variable @SortDir, which could be ASC or DESC?

Using the same method used for the Sort Expression (CASE)...

I am just wondering if simplest is the best option here...

Get the top record (sorted in date descending order before the query time) for the accountID

get its active status

if there...

got to be the distinct clauses way of handling things right?

I wonder if instead of a distinct at the head of the statement a group by at the foot would...

if the string is also 3+ char why not use the left function as well?

I think the correct syntax for the case statement in this option is

CASE

WHEN len(servcode) >...

I agree.

Its a matter of the way we do things.

As an App developer we often focus on singular objects or instances.

But as database developers we focus on not one object...

looks like you result convert isnt big enough to start with char(6) wont hold dd_-_mmm_-_yyyy

the format of type 6 give the two diget year you displayed and 106 gives the...