This is one of two reasons I don't use the execute SQL task. If I get called at 1 AM because the SQL failed I want to know where...

Nevyn (10/23/2013)

---

How much of a salary decrease would you take for more vacation? Using Dave's number say you are making $40 an hour, for a 40 hour week thats...

Great points Dave. I was just looking at it from a benefits side, not salary. Just trying to think of a way to help those who don't. ...

LightVader (10/23/2013)

---

GeorgeCopeland (10/23/2013)

---

I disagree. Just because you are a good programmer, developer, DBA, or whatever, doesn't mean you are a good negotiator. I'm happy you are a good...

I disagree. Just because you are a good programmer,...

Richard Warr (10/23/2013)

---

In the UK the legal minimum is 28 days including public holidays. Many companies offer a week more than that and give additional holiday to longer-serving employees. This...

Gary Varga (10/23/2013)

---

below86 (10/23/2013)

---

Not to open a can of worms from a previous post, but for those of you with less time, wouldn't a union be great to fight for...

ryk 98103 (10/23/2013)

---

I know we can get caught up in work, but, geez, definitely take all the time you have coming! I love my job, but how many of us...

WOW only 10 days for vacation and sick, no way I could work for your company. I get 25 vacation days, 8 paid holidays, and I accrue 5...

I knew I forgot something, added to the where clause so you don't update to much.

UPDATE Table_B

SET tree = 'Middle East',

[entry] = 5

FROM Table_B

WHERE tree = 'Africa'

and job_number in (SELECT...

I did't try testing this but would this be what you want?

UPDATE Table_B

SET tree = 'Middle East',

[entry] = 5

FROM Table_B

WHERE job_number in (SELECT job_number

FROM Table_B

WHERE tree = 'Egypt'

GROUP BY job_number)

enriquezreyjoseph (10/9/2013)

---

dwain.c (10/8/2013)

---

The best learning is by doing, and I agree that this site is extraordinary for this.

Pick a problem that someone has posted and try to solve it yourself....

We have one DBA, about 16 developers, and about 10 what I call 'power users'. These 'power' users usually write small queries to get some detail level data from...

I'm with Simon here. You stick with what works, what is simplist (KISS principle) and what you can get done quickly. You look for better ways to do things, but...

Thanks for the info Sean, I thought a table would be the best way to go. I don't think this example with completely work but I've got the general...