SQL_Learning (5/23/2013)

---

Thanks for the reply, I think this update statement is only for updating a particular column but i have to update all of my columns, tables in my entire...

After reading Howard's explanation do you now understand why that is?

RedBirdOBX (5/23/2013)

---

Newbie question here. But...if I don't ask, I dont learn.

Writing and testing a new SP which will insert data to a table. While testing, I'm trying to...

GOODS (5/23/2013)

---

Hi Guys,

I'm designing a report in SSRS,I need to pull that from DB from previous Friday till the end of the current Friday.

this is what I have on WHERE...

Steve Jones - SSC Editor (5/22/2013)

---

Sean Lange (5/22/2013)

---

Steve Jones - SSC Editor (5/21/2013)

---

Grant has a Surface RT. However Sean said "For the Touch I do not have the newer version...

Do be careful when doing "non-equi" joins.

http://www.sqlservercentral.com/articles/T-SQL/61539/%5B/url%5D

DavidMcAfee (5/22/2013)

---

Thanks for that link. I downloaded it and installed it.

I don't know if I am doing something wrong, but it doesn't seem to do anything when I type into...

Lowell (5/22/2013)

---

OK I stopped dragging my feet, and broke down and downloaded Redgate's SQL Search;

I admit it, i already see it's a great tool; very nice. Much Quicker and...

That is huge understatement. It is nowhere near good practice to store column headers in the table. :w00t:

Bad practice aside...

Check out SQL Search. It is 100% and written by RedGate, the sponsors of SSC. 😀

http://www.red-gate.com/products/sql-development/sql-search/%5B/url%5D

Isn't that whole thing pretty much the same as this?

from

examination as b

left join preliminary_exam on b.procedure_id = preliminary_exam.id

left join pathology on b.procedure_id = pathology.id

I would recommend that you too...

Take a look at RedGate's SQL Search. It is free and totally awesome for this type of thing.

I would argue that you should worry about it. Just because you...

Coriolan (5/21/2013)

---

I am looking for your advice.

We have a calendar for each organization where the total count of the org events is kept. Each organization can have 1 or...