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

😎

Lynn Pettis (1/5/2015)

---

No real difference between CAST and CONVERT unless you need to use a style code for the conversion. Also, if you listen to Mr. Celko, CAST is...

Duplicate thread, answer in this thread

😎

salardx (1/5/2015)

---

Hi guys, I read this link and I have exactly the same problem:

http://www.sqlservercentral.com/Forums/Topic613703-338-1.aspx

But the solution doesn't work for me! I got a type as table:

CREATE TYPE [dbo].[User_Ven_Att] AS TABLE(

[userName]...

Quick fix using row_number in a sub query, just adjust as needed

😎

USE tempdb;

GO

SET...

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first destination table,...

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first destination table, one merge operation on...

knikolov4521 (1/4/2015)

---

Hello, can someone help me with this:

I have two tables. I have three columns DEPARTMENT_NAME, LAST_NAME, JOB_ID.

DEPARTMENT_NAME is from table 1. JOB_ID and LAST_NAME are from table 2....

KoldCoffee (1/4/2015)

---

Answers:

1: one remote location for the...