Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 order by function

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-19 : 09:38:56
wilson writes "I have a problem in my store procedure where within the procedure i have a statement to insert into a work table from a source table but inserting in a certain order which is custid.

so i use the
insert into .....
select from .....
order by custid

but the order by function don't seems to work and i tried other methods like inserting dummy queries.

just to let you know the values inserted include input variable values and fields from source thable"

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-09-19 : 09:56:37
Please post the whole statement so we can help.

Go to Top of Page
   

- Advertisement -