Luis Cazares (10/30/2013)

---

I wasn't saying that stored procedures save a log automatically, but are a simple way to manage your T-SQL code without touching the SSIS packages.

For the error logging,...

Luis Cazares (10/30/2013)

---

below86 (10/30/2013)

---

So until someone can tell me how I can see this same type of 'log' information for an execution of a SQL job, I will not be...

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...