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. ...

Jeff Moden (1/6/2015)

---

Forget about CHOOSE here. Forget about WHILE loops here. The following will generate as many random vowels (up to about 16 million) as you need in...

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. It's normally a...

jwiseh (1/5/2015)

---

On my SQL Server 2012 SP2 installation, The following expression always returns an integer between 1 and 6:

[font="Courier New"]SELECT CEILING(RAND()*6)[/font]

...but this function only works half the time, returning...

gmsharma11 (1/5/2015)

---

Hi Guys,

Please help me out!! AsAp...

I have a unstructured XML files …. Means … each file can have different no of NODES…

So please let me know how I can...

Foggy glasses are more the problem on this end:smooooth:

For completeness, the...

The initial solution does convert column names to dates, something that's not applicable in the later data sample, no problem really, will post the code when I have the time....

Always do listen to JC, don't always agree though.;-)

😎