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!

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

Search results for query: *

  • Users: hollander
  • Content: Threads
  • Order by date
  1. hollander

    Hyphen not working in WHERE of stored procedure

    I have a really odd scenario that I can't seem to find a solution to (unless it's that basic!). It has to do with a hyphen in the value being passed to a stored procedure that's doing an UPDATE. The procedure is of the form: UPDATE tblItem SET NextNumber = @num WHERE (ItemNumber = @item)...
  2. hollander

    Creating a duplicate record in a table with an identity field

    I've searched as many ways as I can and have not found a solution to this, so I'm guessing it can't be done (at least not easily). However, I figured I'd through it out there and see if I'm missing something obvious. I'm looking for a SQL statement that will allow me to INSERT INTO tbl SELECT...
  3. hollander

    M3903 disabled after being unplugged

    Someone left their M3903 phone unplugged overnight. Now they don't have dial-tone. I recall someone telling me that if a phone is unplugged for more than so many minutes/hours, that the Option 11C will "disable" the port. Does anyone know how to re-enable it? Also, for someone...

Part and Inventory Search

Back
Top