Archives of the TeradataForum

Message Posted: Fri, 23 Mar 2007 @ 18:01:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

John

I have not tried this but I think what you can do is create a macro where your fields that you are ordering could be the input fields. This can be MyMacro (field1 char(1) , field2 char(2) etc), now on your SQL statement you can use Order by :field1, :field2 desc etc. This will let you pass the parameter to it.

As far the .net you just handle the fields as input and call this macro the same way you call an SP and pass the parameter.

Good Luck!

Mohommod

	<Prev	Next>		<<First	<Prev	Next>	Last>>