Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is...

Sean Lange (9/25/2014)

---

That is hilarious!!! Hopefully the...

Should have been, have you ever written/submitted a... ~~~~\o/~~~/\~~

😎

Thanks Sourav for the question, must admit it did raise few questions though, cannot consider these to be the lowest hanging fruits in the forest.

😎

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going...

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately....

is there a difference?

Share...

Too much of an effort:-D

😎

Not really, you can load the results from the DelimitedSplit8K function into a temp table, can be beneficial, especially if you...

My 2Cents and a workable workaround, always preview! Had few embarrassments in the past:blush:

😎

Quick question if StorePurchaseDate is not null is the OnlinePurchaseDate null and vice versa? Or do you have an OnlinePurchase flag?

😎

Quick solution, not perfect but it works most of the time

😎

SELECT

P.Name_Section

,T.Name_Section AS Matched_row

FROM @T T

OUTER APPLY @P P

WHERE CHARINDEX(';' + P.Name_Section,';' + T.Name_Section +...

Just being a "little" pedantic and of course way off topic, for ad hoc sequence generation, sys.syscolumns is not the best choice, consider these three queries

😎

/* Query one, relative cost...

Quick thought, although source control systems are fine and in fact should always be in place, they are not holistic/comprehensive change management/monitoring/control systems. For those purposes they rely on...

TomThomson (9/25/2014)

---

Good question, but two small flaws:

1: the explanation is misleading. It says "The RAND function only produces one value for all calls in a specific connection with a...