Professional Web Applications Themes

Status Table for Cursor - Microsoft SQL / MS SQL Server

What's the easiest way to log success or failure on rows manipulated with a cursor. Example. Each successfully processed row throught the cursor writes a 1 or 0 to a status column of the associated data. Any help would be great! Thanks!...

  1. #1

    Default Status Table for Cursor

    What's the easiest way to log success
    or failure on rows manipulated with a cursor.

    Example. Each successfully processed row
    throught the cursor writes a 1 or 0 to a status
    column of the associated data.

    Any help would be great! Thanks!
    .matt Guest

  2. #2

    Default Re: Status Table for Cursor

    Are you sure you need a cursor? Usually, cursors have lower performance
    than a set-based operation, are unnecessary, and are used because the
    problem is approached from a procedural frame of mind.

    If you could accomplish whatever you're doing in a single set operation, you
    could use the same where clause to update the status column.





    ".matt" <mattmurren-inc.com> wrote in message
    news:02ef01c33f3e$74d2cc40$a301280aphx.gbl...
    > What's the easiest way to log success
    > or failure on rows manipulated with a cursor.
    >
    > Example. Each successfully processed row
    > throught the cursor writes a 1 or 0 to a status
    > column of the associated data.
    >
    > Any help would be great! Thanks!

    Aaron Bertrand - MVP Guest

Similar Threads

  1. Cursor Jumps out of table
    By Mr Eastwood in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: May 26th, 03:37 PM
  2. SHOW TABLE STATUS & Autoincrement???
    By soup_or_power@yahoo.com in forum MySQL
    Replies: 3
    Last Post: May 16th, 05:06 PM
  3. cursor 200-problem on mac but not pc? how to swap cursor image?
    By nickelsock webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 5
    Last Post: August 2nd, 10:58 AM
  4. Replies: 0
    Last Post: July 11th, 08:18 PM
  5. Change the "web hand" cursor in normal arrow cursor?
    By FB1976 in forum Adobe Dreamweaver & Contribute
    Replies: 1
    Last Post: July 9th, 07:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139