ashuthinks (5/7/2012)

---

I need to put where condition inside NOT EXISTS clause in sql.

In below need to check the duplicate records for that in below sql query i need to put...

If I may also point out. The page being pointed to does not list the SQL Server version. It lists the Visual Studio version. Therefore it does...

GilaMonster (4/19/2012)

---

I should add, I've promised myself The Old Republic as a 'thesis submitted' purchase, and I'll probably lose a few months to that.

Considering trying out EVE. Thought I'd download...

maybe if you could write out a full sql definition example that you are looking for.

Something like the below. Don't include the dynamic part, just what the output should...

Here's another alternative. I haven't tested the performance as I don't have a setup to do that, and I don't know if it will be similar to Jeff's in...

L' Eomot Inversé (3/22/2012)

---

Interesting. I don't trust BoL to be right 100% of the time, nor SSMS (for example both claim that many things in master with names beginning...

Hugo Kornelis (3/21/2012)

---

Nice question on a little known (and, frankly, barely useful) feature.

Too bad it is hampered by the all too common mistake of depending on a time format. In...

Stefan Krzywicki (3/14/2012)

---

venoym (3/14/2012)

---

I've let my son (age 3) watch them in a certain order. So far he's done episodes 4, 6 and then 1. No offense to...

I've let my son (age 3) watch them in a certain order. So far he's done episodes 4, 6 and then 1. No offense to anyone, but letting...

Well, I figured out the answer in my case. What happened is that somehow (I still don't know how) an sa user and schema were created in that...

A split function will work well. Keep in mind that in compatibility for SQL 2000 you can't always use a function on a column. So you may have...

I've implemented a service broker architecture for an application. The biggest problem with Service Broker is the fact that any error in Service Broker is severity 16 and causes...

Stephanie Giovannini (3/2/2012)

---

Actually, it looks like there are two errors. The first error is the nonexistent dialog id. The second error is attempting to commit an uncommittable transaction after the...

Actually, on point b), not so much

http://www.cepr.net/index.php/blogs/cepr-blog/its-so-hard-to-get-good-help?utm_source=CEPR+feedburner&utm_medium=feed&utm_campaign=Feed%3A+cepr+%28CEPR%29

While some companies say they have lots of openings, the data says otherwise.

I'm basing my disagreement with you based on scientific studies I've read...

Stephanie Giovannini (3/2/2012)

---

So, how would you fix the posted code so that the uncommittable transaction message isn't reported?

I'm curious which COMMIT statement is causing the error. There's a COMMIT statement...