Thanks Jeff, those are very helpful! I like that way of describing what's going on. Good to see you also. I haven't been here in years, but I do remember...

Oh I see now! I'm going to have to spend the rest of the day learning CROSS APPLY. I've been doing SQL for 20 years and that one still confuses...

We have to leave that function in place because other apps use it to generate single codes when needed. It is the approved method of generating codes and I didn't...

OK this is what I came up with... this works quite well.
CREATE FUNCTION dbo.GetMultiplePromoCodes(@NumCodes int)
RETURNS @PromoCodes TABLE
(
  PromoCode nvarchar(10)
)
AS
BEGIN

I am free to do whatever I want. Currently the function only generates one new "random" promo code (it's what the customer types in to the checkout to get their...

I agree this is a "trick" question of a sort. They aren't asking this to get an answer, but more to see how you think. It's an open-ended question designed...

I only worked there for two months, and I didn't do anything and didn't get to know anybody - they all hated me for some reason. It really was weird....

Oh yeah I know that, I've been doing this stuff for over 20 years. It isn't maybe as bad as I made it sound. I just didn't like the place....

LOL, better things come up and sometimes you have to irritate someone in order to take advantage. I left in an unprofessional way, but I had to do it that...

Well I hope it doesn't cause any "issues" because I don't have that job any more and I'm never speaking to them again!

Sean Lange (2/11/2013)

Actually begin...

You should probably thank me for that...

I found out how to fix it. It's in the Control Panel->User Accounts->Manage Your Credentials

One of the things in the "Vault" was the user it was picking for deployment. Deleting...

I added some comments to your proc, and fixed the layout, formatting, capitalization - all of which was horrifying to begin with. Pick a coding standard and then use it....