OK,

Here we go.

The test as promissed.

Starting with creating a table:

CREATE TABLE [dbo].[UsedRedemptionCodesTest](

[RedemptionCodeID] [int] IDENTITY(1,1) NOT NULL,

[RedemptionCode] [char](36) NULL,

[IsActive] [bit] NOT NULL,

CONSTRAINT [PK_UsedRedemptionCodesTest_RedemptionCodeID] PRIMARY KEY CLUSTERED ([IsActive], [RedemptionCodeID] ASC))

CREATE UNIQUE NONCLUSTERED...

what does that mean?

In English, please.

Have a look at the topic starter:

SET @RedemptionCode = dbo.GenerateRandomBase32(@RedemptionSeed)

WHILE((@RedemptionCode IS NULL) OR EXISTS(SELECT RedemptionCode FROM...

ScottPletcher (11/19/2015)

---

When one campaign is over all the relevant promo codes are made inactive.

Yes, by deleting them from the current promo table, not by just flagging them. They can...

ScottPletcher (11/19/2015)

---

No person outside the company can possibly put it back into the current table. So how would they ever be able to reuse it? It's just not...

ScottPletcher (11/19/2015)

---

Try to follow this, it's simple enough even for you.

When it's used up initially, it's removed forever from the current table, since it has no current value.

No person outside...

ScottPletcher (11/19/2015)

---

Sergiy (11/19/2015)

How exactly you intend to prevent used codes from being reused (regenerated as new) if...

j-1064772 (11/19/2015)

---

I was more thinking of the "main" tables like Customer, Contact, Invoice. No duplication issues there.

And yes, I agree that there is still work to be done for "reference"...

ScottPletcher (11/19/2015)

---

Sergiy (11/18/2015)

---

How exactly you intend to prevent used codes from being reused (regenerated as new) if...

j-1064772 (11/18/2015)

---

If two offices of an organization used the same application each maintaining its own database, then at a later time the two databases could be merged without any risk...

How exactly you intend to prevent used codes from being reused (regenerated as new) if they are...

I use to top up my mobile by texting recharge codes to provider's number.

All the numbers I ever used are still sitting in the memory of my phone.

If the provider...

Why not?

May be not "ever issued", may be...

ScottPletcher (11/18/2015)

---

Of course. But that doesn't mean I have to store decades worth of obsolete numbers in my main table, now does it? If the number is not...

sql.queries (11/18/2015)

---

One other advantage of GUIDs could be when you need to join two equal tables, for example, two tables of users which were filled in different places and keep...