As implied, the concept has been around for a long time, tends to be shaped somewhat by whichever technology is in at the time. In my opinion, tossing in another...

For completeness (and some fun :-)) here are two other solutions for 2012 and later

😎

Almost direct translation to window function version, uses LAG instead of aggregation for the cross row...

Quick but slightly verbose solution, does only scan the table once but that comes at an additional cost, would be a perfect case for LAG/LEAD on SQL Server 2012 or...

Dee Dee-422077 (1/9/2015)

---

Hi,

My example data as this:

ID code1 code2

1 a ...

Got it printed in a folder along with your's (about three years back) and Phil Factor's last years RBARR / RBAR-RAND one;-)

😎

Jeff Moden (1/9/2015)

---

I personally don't know of any programming language that actually has a true random number generator function. That's not to say that there isn't one but I...

JP10 (1/9/2015)

---

Ok I have a query "SELECT ColumnNames FROM tbl1" let's say the values returned are "age,sex,race".

Now I want to be able to create an "update" statement like "UPATE tbl2...

Jeff Moden (1/9/2015)

---

Eirikur Eiriksson (1/9/2015)

---

My thought is that some of the random function implementations in SQL Server are more caused by the limitations of this particular function ( RAND() )...

My thought is that some of the random function implementations in SQL Server are more caused by the limitations of this particular function ( RAND() ) rather than anything else....

Quick thought, an alternative way of getting an execution plan for this kind of simple statements is to use a CTE, has less inpact/noise in the plan as it's normally...

Luis Cazares (1/8/2015)

---

spaghettidba (1/8/2015)

---

Maybe. Meanwhile, no response from...

Now all you have to do is to create a SQL Job that posts random text to...

Meatloaf (1/7/2015)

---

Thank you! Here is my code:

Dim objConn, objRS, strQuery,strConnection

set objConn = Server.CreateObject("ADODB.Connection")

set objRS = Server.CreateObject("ADODB.RecordSet")

strConnection = "User ID=xx;Password=xxxxxxxxxx;"

strConnection = strConnection & "Driver={SQL Server};Server=DB_Server_NAME;Database=MY_DB;"...

Meatloaf (1/7/2015)

---

Hello I am trying to connect to a database from a server with SQL Server 2012 to SQL Server 2005 for some reason I cannot get it to work...

ScottPletcher (1/6/2015)

---

Eirikur Eiriksson (1/6/2015)

---

ScottPletcher (1/6/2015)

---

Jeff Moden (1/4/2015)

---

Trust me Dhani, we know what it does and folks in-the-know can't just ignore it. ...