Thomas Abraham (1/30/2014)

---

When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import, broken it...

Ryan George (1/30/2014)

---

it is really interesting to hear. In a table, two prmary keys.

but this is a question which i got for an interview

i had options too. :doze:

as per the...

vignesh.ms (1/30/2014)

---

Lowell (1/29/2014)

---

great job posting sample data! post slike this make me want to help!

here's an example of a set based operation using a well know technique with FOR XML;

the...

Again the...

dany.donaldson (1/29/2014)

---

Thank you Sean, i've been reading similar ideas but none have that clear. I ran the code and it failed - "CREATE PROCEDURE permission denied in database"...

alanspeckman (1/29/2014)

---

As part of database cosolidation, I have 4 databases that were hosted on 4 different servers.

Each database is for a different customer in different timezones.

I use to...

dany.donaldson (1/29/2014)

---

I'm using Access as a front-end application and SQLServer on the back-end. There is one particular report that locks up Access when I try to run it and...

Hi Alex. Welcome to the forums. It would be greatly beneficial if you could provide ddl and sample data in a consumable format. You can get some details about how...

You are looking at a very code intensive piece of work to pull this off. What you are trying to do is to actually move columns values from one to...

rootfixxxer (1/29/2014)

---

The extra "lines", vars and everything was for testing purposes, trial and error... And looks like these lines were the responsible for the problems... 🙁

But anyway, thanks for the...

Chad, glad that worked for you and thanks for posting your final query that worked.

huh?

wolfkillj (1/29/2014)

---

Sean Lange (1/29/2014)

---

wolfkillj (1/29/2014)

---

Ed Wagner (1/29/2014)

---

Greg Edwards-268690 (1/29/2014)

---

GilaMonster (1/29/2014)

---

Ed Wagner (1/29/2014)

---

GilaMonster (1/29/2014)

---

Could use some of that chill down here. We had a couple of weeks of 35 C+ (high...

rootfixxxer (1/29/2014)

---

Hi

I created a trigger to handle one business requirement in my company, the trigger checks if the insert or update statement adds/changes one field of the table to a...

wolfkillj (1/29/2014)

---

Ed Wagner (1/29/2014)

---

Greg Edwards-268690 (1/29/2014)

---

GilaMonster (1/29/2014)

---

Ed Wagner (1/29/2014)

---

GilaMonster (1/29/2014)

---

Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously...