Simple query will do it.

Something like this:

SELECT *

FROM Details D

INNER JOIN Eligibility E ON D.[Service Date] BETWEEN E.[From Date] AND E.[To Date]

No cursors needed.

Jeff Moden (1/17/2009)

---

If I were doing mortgage calculations, and let's assume that the max limit on the mortgage were, say, ummm... a penny less than a billion dollars... which would...

In science there is no space for someone's decisions.

You...

DECLARE @One decimal, @Three decimal

SET @One = 1

SET @Three = 3

SELECT @One/@Three + @One/@Three + @One/@Three

Is...

SELECT MIN(Date), -- use some formatting here if you need it

MAX((Date), -- again, format the string to the requirements

...

You should replace "{Unique Key}" with column(s) which intend to hold unique values.

In your case it's probably TowID, but you should know better.

ps, your solution will delete only part of candidates.

If there are 3 identical rows it will leave 3rd row in the table.

Try this:

DELETE R

FROM [tower].[NBDocUpdatedRecords] R

LEFT JOIN ( select MIN(ReplicationID),...

Jason, what you describe in your lost post is presenting datetime values in different string formats.

It has nothing to do with splitting date and time parts.

And solution in SQL2k is...

Janette,

Problem is: my solution

ORDER BY AlphanumericValue

works perfectly for the dataset you provided:

100

101

102

etc...

Wanna better answer - take some care about asking better question.

The answer is:

ORDER BY AlphanumericValue

dejanette.gordon (12/17/2008)

---

I have a query where the datatype I'm ordering by is varchar(10) but when I use the ORDER BY the values come out like this: How do I work...

So, you change the views.

Absolutely fine.

But where...

Even less calculations:

select

OrderID,

OrderDate,

ShippedDate,

RequiredDate,

ShippingWindowDays,

OrderWindowDays

...

Just don't update what does not need to be updated:

update [my_table]

set [row_uid] = newid()

...

If you don't know other way it does not mean there is no other way.