stuffed crust

Just like Chris showed you above. Just take it out. It doesn't do anything except slow down your code. Two values are equivalent when...

despicable

SQLRNNR (7/7/2014)

---

Luis Cazares (7/7/2014)

---

wolfkillj (7/7/2014)

---

Sean Lange (7/2/2014)

---

Stefan Krzywicki (7/2/2014)

---

Sean Lange (7/2/2014)

---

Stefan Krzywicki (7/2/2014)

---

Koen Verbeeck (7/2/2014)

---

Jo Pattyn (7/1/2014)

---

Funny! :w00t:

Anyway the Belgium Red Devils got past the USA soccer team after a...

swaseem345 (7/7/2014)

---

Oh thank you very much! I now see exactly what your talking about and of what your query is stating. The problem I have is I know functions of...

wolfkillj (7/7/2014)

---

Sean Lange (7/2/2014)

---

Stefan Krzywicki (7/2/2014)

---

Sean Lange (7/2/2014)

---

Stefan Krzywicki (7/2/2014)

---

Koen Verbeeck (7/2/2014)

---

It was...

I kind of wondered if that was an interview question. It seems to me like a...

You are on the right path but you need to normalize Make and Model. Consider what you would have to do with this structure if the Model name was wrong....

GilaMonster (7/7/2014)

---

Sean Lange (7/7/2014)

---

info 58414 (7/7/2014)

---

Hi,

in a StoredProc I want depending on whether a parameter is passed formulate the Where clause accordingly.

If parameter IS NOT NULL

...

sql_novice_2007 (7/7/2014)

---

Hi,

I have the following data

UIdCOIDCLIdSID

1 109

1210

1 320

1439

2 502

2513

2529

2 533

2540

2600

2610

2620

2630

2640

2 700

2710

2720

2731

2740

I need the following result from the above data

UnIdCoIDClIdSID

1109

1219

1320

1439

2502

2515

2529

2533

2540

2600

2610

2620

2630

2640

2700

2710

2720

2731

2740

The query needs to add Sid value when...

Krasavita (7/7/2014)

---

Msg 306, Level 16, State 2, Line 57

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Msg 4104, Level...

info 58414 (7/7/2014)

---

Hi,

in a StoredProc I want depending on whether a parameter is passed formulate the Where clause accordingly.

If parameter IS NOT NULL

THEN...

I would also refrain from prefixing your tables with "t". And don't be scared to give your tables and columns longer names so it is easy to understand what they...

Krasavita (7/7/2014)

---

Hello,

I have the following code and creates slow performance what else can I make it simpler? (Thank you very much:

SELECT * INTO #Timesheet

FROM (

SELECT s.Sheet_ID,...

NO. This will not return rows where Sheet_ID currently set to NULL. This...