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

Working with the fuzzy lookup was actually quite fun. I can...

Here is another option:

select

run_date,

run_time,

cast(cast(run_date as varchar(8)) + ' ' + stuff(stuff(right('000000' + cast(run_time as varchar(6)), 6),5,0,':'),3,0,':') as datetime)

from

...

No, SQL Server does not track the creation of individual records in a table.

[font="Tahoma"]Merry Christmas and a Happy New Year to All[/font]

I like SSIS. For the most part we use it to move data between servers or to import/export data. Most data transformations, however, are done using SQL in...

CirquedeSQLeil (12/21/2009)

---

Lynn Pettis (12/21/2009)

---

Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). Are you...

Jason Jeffery is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). Are you sure you...

We need a little more to help. We could use the table structures, sample data demonstrating the problem, expected results based on the sample data. For assistance in...

It isn't an end all or silver bullet. But that doesn't mean it isn't something that can be enhanced and further developed to enhance the security of local databases.

Have...

Standard answer here, It Depends. I would not have it as a default, but a development team working on a distributed app may see the usefulness of using TDE...

SQL Iron Chef (12/21/2009)

---

Actually I didn't! I was just trying to digest someone...

I know, and you have to explicitly code for the encryption, you can't just encrypt the database like you can with TDE in SQL Server 2008 EE. That is...