Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by koooob

  1. koooob

    Selecting from xml field

    Well. That's weird. It does work. I swear it didn't work before I posted. I must have done something weird. Anyway... thanks for pointing out that it does work!
  2. koooob

    Basic query a problem (hurts my head -.- )

    If you are on sql server, you could create a function that gives you the id of the post. Not sure about performance but it will work (I've used this method for things before) so in query analyser create this function: CREATE FUNCTION dbo.last_forum_post_id ( @topic_id uniqueidentifier )...
  3. koooob

    Selecting from xml field

    Hi there can someone help me with a problem - it should be fairly straightforward but I'm a bit new to xml and can't quite find any examples of what I'm trying to do. in short, I have some xml stored in a database (sql server 2000) and I want to select a field value. here is some sample code...
  4. koooob

    Transactions in Cursors

    OK thanks, will do Kuba
  5. koooob

    Transactions in Cursors

    Sorry should have said - 2000
  6. koooob

    Transactions in Cursors

    Hi, hope somebody can help me out here. I'm writing an import script that goes through a result set using a cursor. This executes several inserts and updates depending on the data in that row, adds an id to another table to show I've dealt with that record then goes onto the next record. What...

Part and Inventory Search

Back
Top