+1000 That one drives me nuts!!! (ok I know it is a short trip)

SQL is delicious (5/29/2014)

---

Sean Lange (5/29/2014)

---

SQL is delicious (5/29/2014)

---

KoldCoffee (5/29/2014)

---

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables to get...

SQL is delicious (5/29/2014)

---

KoldCoffee (5/29/2014)

---

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables to get the most out of the...

KoldCoffee (5/29/2014)

---

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables to get the most out of the 'how'. But...

KoldCoffee (5/29/2014)

---

Hi, I'm reading sql stuff and came across creating functions to split strings into columns/tables. Since the only time I've had to split up a row into columns is...

samalex (5/29/2014)

---

Wow, I agree with literally 100% of what you guys have entered, including 'sprocs'. We have a few non-DBA's who use this verbiage, and it always makes me cringe....

Mr. Kapsicum (5/29/2014)

---

Hi,

This Data Type is of the Source Table. We Insert Data from Mysql DB to SQL Server.

The Data Type for few columns in Source Table is Decimal(65,2), so...

How big are...

Eirikur Eiriksson (5/29/2014)

---

Sean Lange (5/29/2014)

---

My code does two very important things. First, it only updates the rows that need to be updated instead of updating them all. Secondly it references...

Rog Saber (5/29/2014)

---

I have 2 tables - a user table (TB_USERS) and a user customer table (TB_USER_CUST). I want to select all the users that share the same customer with...

jbalbo (5/29/2014)

---

Hi

Not sure why I'm stuck on this.. but I am

I have a parameter called activestatus values are "A" for Active or "B" for "All"

I want to filter the...

My code does two very important things. First, it only updates the rows that need to be updated instead of updating them all. Secondly it references the alias in the...

Let's see...in no particular order.

storing datetime in ANY other datatype.

NOLOCK

Poor formatting

Not having a space between parameters in a function call (parm1,parm2,parm3)

Not having a space in a where clause or join...

eyric101 (5/29/2014)

---

It takes more then 30 seconds to run

DECLARE @intTmpTblCnt INT,

@strTmpSql VARCHAR(max),

...

tshad (5/29/2014)

---

I have a situation where I want to update a column if and only if it is null.

UPDATE Employee

SET VEmployeeID = CASE WHEN E.VEmployeeID IS NULL

...