Why do you ask? Is there something wrong with the proposed solution, such as your neglecting to tell us that...

Try the following:

SELECT ord_oda_id, token, ISNULL(ord_id, 5000) AS ord_id

FROM xx_pm_receipts

OUTER APPLY (

SELECT TOP (1) ord_id + 1 AS ord_id

FROM xx_ordid_tracker

WHERE poid = ord_oda_id

ORDER BY ord_id DESC ) AS ot

WHERE token...

If you're trying to do what I think you are, then the answer is that you can't do it in SQL. First Normal Form for databases is that all...

I disagree. While I'm sure that the intention is that the statement before must end with a semicolon, implementation and general practice clearly...

STOP!!!! You're opening yourself up to a very serious security risk. Identity theft is a very big problem and the primary source is SSNs from hacked databases.

You should...

The issue...

Try NTILE().

Drew

You should NEVER use BETWEEN with datetime data. Your query assumes a precision of 1 second when the actual precision of datetime data is 3 milliseconds, so you are...

Until SQL support Boolean datatypes, bit flags are the next best thing.

, but you did not bother to post any DDL...

I think that we would all agree that the following strings should all produce the same results when converted to an integer:

' 1'

'01'

So, it makes sense to me, that if...

Note that "b.date_deactivated is not NULL" is superfluous. If b.date_deactivated is NULL then the result of "b.date_deactivated < '7 aug 2012'" will also be NULL. So, in order...

As Joe alluded to, there is a much simpler method of calculating intersections. The standard uses only two dates, but it easily be modified to account for multiple dates.

SELECT...

Without data, it's hard to say what the best approach is, but consider using CROSS APPLY instead of the CURSOR. Here's something that will help get you started.

SELECT EvaluateeEvaluationID,...

kaushal_shah26 (8/2/2012)

---

I googled the syntax and changed the query to include partition and also pull only records where isactive =1. The reason for pulling only isactive = 1 is we...

kaushal_shah26 (8/2/2012)

---

Thanks for the code. It works for the sample code. Now, How do we do this for all types. In the sample code, we only have one type which...