Search results for query: *

Thx!

Hi SQLSister, OMG, I'M SUCH AN IDIOT! Here's the proc, CREATE PROCEDURE [sp_DC1setNextNumber] (@item [varchar](10), @num [varchar](10)) AS UPDATE tblItem SET EndingMailerNumber = @num WHERE (ItemNumber = @item) GO The problem was not with the hyphen, it was with the length of the value in...

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)...

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...

Thanks OsakaWebbie!!!!!!!!!!!! I have been searching and searching for a solution to this problem. I downloaded scriptx this morning, and within 10 minutes, my headers and footers were gone! It would be great if this solution could be posted in the FAQ section because it seems like there's a...

Thanks Colin, all is well again. Oh how I wish I had my Lucent switch back!!!

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...