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

You do know that the NOLOCK hint on the update is ignored, right?

Forgetting your problem at the moment, let me get this straight; database using full recovery model, daily full backups, no transaction log backups? You do realize that the transaction...

Nevermind, clicked wrong link.