• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

retrieve same order

yes I am using a cursor.
Now when the cursor executes it pulls multiply tables
what is does take each invoice number and pulls all info related to the invoice number.
Then i insert it in the temp table. The problem I am having once in the temp table all the data is bunch
together.  now I need the data to look in the same order it was retrieved.

any suggestions.
0
Seven price
Asked:
Seven price
1 Solution
 
vastoCommented:
When you create the temp table add an identity or timestamp field
0
 
Seven priceFull StackAuthor Commented:
timestamp  worked great,  Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now