john.henderson (7/1/2008)

---

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

john.henderson (7/1/2008)

---

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

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) doesn't seem...

Hey thanks guys, that will work. The overhead is temporary, this is a  'boss lost the source code' problem, so I just have to run the trace long enough to see...

Thanks, I'll try the UDF. Can someone post a sample UDF so I can see the correct syntax?

 

I need the procedure as part of a select statement in another procedure. I tested this and it worked (@LASTNAME is a parameter of otherproc).

This is the FULL stored...

My procedure also has parameters. So from inside the other stored procedure, if I want the value it returns, I would type:

 

SELECT ( exec MyProc )

 

What about the...

Thanks for all the replies! This is what worked:

IF @CALLLOGTIME IS NULL SET @CALLLOGTIME=0

 

The following did NOT work - gave a syntax error (I don't know why either, they...

Thanks!! It worked perfectly.

One more question, how can I sort by the count(*) ?

it says 'no column name' in the count column, so I can't list it

in...