Slight mod to the code for testing:

--create download code table

create table #DownloadCode

(

dlc uniqueidentifier not null,

dlcmembernumber numeric(13,0),

dlcdatereceived datetime, ...

Here is the original SQL Server 2005/2008 code I had envisioned earlier in the post:

--create download code table

create table #DownloadCode

(

dlc varchar(14) not...

Greg Snidow (12/22/2009)

---

Greg Snidow (12/22/2009)

---

Lynn, that's a neat little trick I...

Here is my SQL Server 2005/2008 code for the same problem:

--create download code table

create table #DownloadCode

(

dlc varchar(14) not null,

dlcmembernumber numeric(13,0),...

Greg Snidow (12/22/2009)

---

Lynn, that's a neat little trick I never thought...

Fridayish -- my apologies, but this is a Friday on a Tuesday today.

Since triggers are synchronous, not going to happen. Well, not true, what you may need to look at is using Service Broker to handle those functions that you need...

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?

(Okay, two posts don't...

I used the row counts to limit the number of downloadcodes loaded to the temp file. Operating in a partial vacuum (more downloadocdes than members but no real numbers)...

Take it easy on the roads. I've heard that a storm is...

Yes. First, if you shrink it, it will just have to grow again. You should size your database (mdf file) such that it has sufficient space for 3...

Chris Morris-439714 (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

Let's take another step back. Help us help you, read the first the article I have referenced below in my signature block. Follow the...

How about something like this?

--create download code table

create table #DownloadCode

(

dlc varchar(14) not null,

dlcmembernumber numeric(13,0),

dlcdatereceived datetime,

dlcdateexpires datetime,

dlcissuedby varchar(50)

)

alter table #DownloadCode add...

Let's take another step back. Help us help you, read the first the article I have referenced below in my signature block. Follow the instructions in that article...

Sorry to join in late, but looking at your stored procedure in the first post, all your stored procedure is doing is setting local variables to what will most likely...