If you're after the one with the lowest POS, this should do it:

SELECT VENDOR_ID, ADDRESS_PHONE_NUM

FROM (

-- Your query (reformatted)

SELECT V.VENDOR_ID, ADDRESS_PHONE_NUM

...

Koen Verbeeck (8/14/2013)

---

And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)

Now that I'm one of the big boyz and Grant...

ChrisM@Work (8/14/2013)

---

dwain.c (8/13/2013)

---

ChrisM@Work (8/13/2013)

---

Here's a sample data generator. I've tested it using Stefan's code and mine and it seems ok. Anyone else up for a race? Package your code into...

Steven - Hey dude, thanks for the credit even though I'm sure my contribution was minimal.

Didn't notice it on publication because I was watching for an article and besides I've...

I know nothing about this but I'll ask a question. Have you tried your query using the ADSI LDAP dialect mentioned in the MS article?

I'd love to hear how...

I have never found a way to suppress them but I confess I haven't looked really hard.

I'd be interested if someone does suggest a way.

Could you use something like this?

USE [TDStep]

GO

SELECT TableName=OBJECT_NAME(OBJECT_ID), st.row_count

FROM sys.dm_db_partition_stats st

WHERE index_id < 2

ORDER BY st.row_count DESC

Due...

If all you're doing is converting feet to meters (or vice versa), why do you even need to UNPIVOT?

I believe there are conversion factors for that. 😛

Wait a minute! That's my SQL Skill Verification test! :w00t:

<stamp>NOT HIRED</stamp>

Create a SQL Agent job that runs a Stored Procedure and sends your email (or not) at the suggested intervals.

I didn't realize you'd reposted this problem.

Here's the SQL 2008 R2 compatible solution I posted in the SQL 2012 forum to your question.

http://www.sqlservercentral.com/Forums/FindPost1484043.aspx

Actually it should be compatible with SQL 2005...

My suggestion is to treat your base records as islands and calculate from them the intervening gaps:

DECLARE @EmpData TABLE

(

employeeId INT

,Activity VARCHAR(10)

...

Interesting results SWEPESO. Didn't think of checking Sunday.

SwePeso (8/11/2013)

---

Remember that SET DATEFIRST will recompile your code. And also, not everyone has DATEFIRST 1 as default setting.

Try this code that is safe and doesn't rely on any setting...