Going to point you in a direction so that you can do some research over the weekend. Start with the link in my signature block about Tally Tables. ...

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more candidates for a position...

Randomly pick? There is no algorithm to use to decide where an order is filled? Sorry, this makes no sense.

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more candidates for a position when they use...

I am so glad I don't have any experience, yet, with replication so that I have no idea what SS is trying to do or why he isn't getting what...

I have to agree with Kevin, contact Microsoft.

Jeff Moden (2/24/2016)

---

First of all, apologies to Lynn Pettis. He's spot on for the solution to this problem but I missed looking at his code. Nice job for...

Please post the original query and the query you are using now without the function.

Could also look at using the windowing functions since this is posted in SQL Server 2014.

Haven't...

Are you still pulling data across the linked server?

You would get a better answer if you posted the query that is giving you the error. Without that all you will get is a shot in the dark.

How about this?

with rcte as (

select

mn.Appl,

mn.Pre_App,

mn.Appl as Original_Appl,

SortKey = 0

from

#mynumbers...

Manie Verster (2/24/2016)

---

Thank you Richard, you have just solved a problem for me of an old problem of giving a valid age. Yes, I know there are most probably many...

Jeff Moden (2/23/2016)

---

Sean Lange (2/23/2016)

---

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com),...