Re:Volatile Tables In Stored_Procedure...

Teradata Applications

Re:Volatile Tables In Stored_Procedure...

Hello Every one,

I have come across a problem in td_Stored Proc volatile tables,

Is  it volatile table  not allowed order by clause?

If it is, when i run the entire stored procedure and need to sort the results and here what is the soultions not alllowing of order by clause

~gopal

Tags (1)
1 REPLY

Re: Re:Volatile Tables In Stored_Procedure...

Is  it volatile table  not allowed order by clause?

> No.

Add a column wrt  sequence No as required , and used it in  "order by "