Sean Lange (8/4/2015)

---

yb751 (8/4/2015)

---

Raise your hands if you like Entity Framework...then I'll know who to shoot!

Sorry just needed two seconds to vent. :crazy:

I'm sure like anything else it can be...

There have also been many issues with using MERGE, up to and including constraint violations. DBCC can even report errors after using MERGE. A quick Google Search will show you...

Sean Lange (8/3/2015)

---

WayneS (8/3/2015)

---

Alvin Ramard (8/3/2015)

---

Jeff Moden (8/2/2015)

---

Alvin Ramard (8/1/2015)

---

Jeff Moden (7/31/2015)

---

You did fine and you're absolutely...

Alvin Ramard (8/3/2015)

---

Jeff Moden (8/2/2015)

---

Alvin Ramard (8/1/2015)

---

Jeff Moden (7/31/2015)

---

You did fine and you're absolutely spot on. ...

Looks like Luis is answering Oracle questions now.

Links added

GilaMonster (7/30/2015)

---

Grant Fritchey (7/30/2015)

---

Brandie Tarvin (7/30/2015)

---

As I dig into this issue (Execution Plans HO!), I come across a thread in which one respondent posts a link to Gail's blog and...

It looks like this article would help you out: Creating a comma-separated list (SQL Spackle)[/url]

joemai (7/29/2015)

---

My case is I have customers with multiple ordering dates, I'll to run a query to pull only records within 2 months period based on the previous picking records....

DiabloZA (7/29/2015)

---

Hi Wayne,

You are right, there is a discrepancy there for the 07/27/2015 for PERSON it should be 08:00 to 10:00 instead of 12:00 to 12:00.

Secondly, we can get rid...

PJ_SQL (7/29/2015)

---

What is the purpose of creating table variable and inserting data into it and selecting from table variable inside of stored proc?

Why can't the stored proc just have select...

parry (7/29/2015)

---

I have a afunction to check the reference number, also a stored procedure is written .

The stored procedure passes the reference number to the function 'checkref' which returns...

sheaS (7/29/2015)

---

Thank you for such a quick reply. Yes, I can convert it to a date, actually in the new app, I had these columns setup as dates but I...

DiabloZA (7/29/2015)

---

Hi Guys,

In need of some SQL help here, I've been trying to hammer this out since over the weekend and it's just not giving me what I need.

Here are...