Thank you for all the input guys. I tried a little of everything to get this tuned, and agree that it is pointless to try to optimize if I can't see...

I just took (and failed) my 462. I went into it blind just so I could meet the free retake deadline. I got 550 out of a needed 700 (with...

Hello, thanks for the reply. Let me clarify. Here is the code application side that inserts the data:

Private Sub LogPackage(ByVal RecordId As Integer)

...

Solved: The records were there, but were not being inserted in order by record id. 'Open table' is SSMS 2005 doesn't sort the records returned by primary id. ...

Thanks rhlangley!

That was a really helpful post so I can see how the two technologies work together. I appreciate the effort you took to help me out. I am...

I am going to rewrite this weekend and use these suggestions. Thanks for the solid advise. I have never used stored procedures before or other aspects of SQL like 'output'...

toddasd (7/7/2011)

---

...

I have a program that inserts a record, returns the record id of the newly inserted record, then inserts another record in another table using the returned row id...

Steve-3_5_7_9 (6/29/2011)

---

Correct, I see "open table" when I bring up SQL 2005 SSMS.

I also do not see the options that I posted earlier. It's only for SQL 2008 SSMS.

I'm...

Steve-3_5_7_9 (6/29/2011)

---

You also may want to check your settings since your "opening" the table instead of running T-SQL statements. I do not have an "open table" option in SSMS....

SQLRNNR (6/28/2011)

---

So from SSMS you can query the table and return results, but when trying to "Open" the table you don't get results.

Do you get an error?

Are you trying to...

Thank you for replying. I am sorry for being confusing... still learning the SQL lingo 😀

SQLRNNR (6/28/2011)

---

So you can query the table and return results. So, how are you...

Anyone?