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

Why not...

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

Now to...

How many more ways can the same question be asked?

http://www.sqlservercentral.com/Forums/Topic837454-148-1.aspx

http://www.sqlservercentral.com/Forums/Topic837318-148-1.aspx

http://www.sqlservercentral.com/Forums/Topic837385-338-1.aspx

By the way, I'd store a date as a date, not a numeric value.

Curious, how many different ways do you plan on asking the same question?

You have asked the same question here and here just worded it a little different.

May I suggest that...

I think you missed my point. Why code both Male and Female preferences when not coding either has the same result? No gender preference is the same as...

Atif Sheikh (12/21/2009)

---

Lets take the business process.

We are designing a Donation System.

1) Now, Donor Donates $100 for Patients with gender=Males and Age between 20-30.

This makes one donations.

2) Now we...

How and where is the patient preferences stored?

This doesn't appear to be defined any where in your problem statement.

FourCallingBirds

Standard answer, It Depends. You may want to do a cost/benefit and ROI analysis of both approaches.

Have you updated the statistics (with fullscan) since moving the database to SQL Server 2005?

Magy (12/21/2009)

---

I think I misunderstood how cursors work...

I figured if I used a SELECT statement and ORDER BY clause with the cursor to populate tmpTable, that the table would appear...