If it can be done transparently at the database level there may be a better chance of developers making use of the technology when it is needed without specialized coding.

I could see developers writing client apps that using Compact and Express editions for holding data in flight locally. TDE may be necessary if those apps hold critical data,...

Joe-420121 (12/21/2009)

---

1. The table has only 4 coulmmns, no FK, constrains etc.

2. The table is used 24 hours, and about 2000 users use it all the time.

3. When I use...

Worked for me when I ran it in SSMS. What error did you get?

Do you have any transaction log and/or differential backups between the previous full backup and this one that appears to be corrupt?

Join me you may, comfortable in the...

Possibly. What is the recover model of the database?

Well, at previous employer we...

You may not want to hear this, but I think your backup file is hosed.

Do you have a previous backup file and differential/transaction log backup files?

CirquedeSQLeil (12/21/2009)

---

Sounds like a riddle - are you plucking petals from a flower as you count the ways? ...

Try this:

select

ID,

case when isnull(Date1,0) < isnull(Date2,0) then Date2 else Date1 end as TheDate

from

dbo.mytable;

Jack Corbett (12/21/2009)

---

Happens all the time, no worries.

YOu could use the second suggestion, have a GMT offset column that is tinyint. So if your offset is 5 (EST) you'd...

rahulsony111 (12/21/2009)

---

I am trying this from 5 hrs and unable to get a solution.

In target table i have that column as numeric.

I tried getdate() with datatype databasedate but it...

Mark Kinnear (12/21/2009)

---

Hi guys

Im trying to find the fastest way to determine the most recent date between 2 fields and extract that one. Here's an example.

mytable

ID Date1...

CirquedeSQLeil (12/21/2009)

---

Lynn Pettis (12/21/2009)

---

CirquedeSQLeil (12/21/2009)

---

I'm curious what the need is to convert a date to a Number. I would leave the date as one of the datetime datatype in...