In the past when we have tried to use views the performance was horrible so we stopped using them. And we avoided using stored procedures as much as possible....

When I tried something similar awhile ago I found it was faster to delete the records from the 'temp' table as I went. I would think this would do...

I guess in the 10+ years I've been writing SQL I haven't found that 'awesome' moment with subqueries yet. Like I said I don't completely avoid them, I do...

Thanks for the info, I'll have to look into 'cool' ways I can use this. I know it's just a simple example but I can't see how I would...

It can be very frustrating looking at other peoples code to try and determine what it is doing. What I like to do is make a copy of it...

Here is some code I've used to try and get this info, it helps cut out some of the clutter, but it still doesn't produce one line per 'step' with...

Sorry for using 'work' table when I mean an intermediate table. If I have process A that normally ran at 10 PM and it created a intermediate table work_db.dbo.policy_list,...

My comment is centered around the use of tempdb over 'work' tables. What I mean is that in the very beginning of us using SQL server we wrote almost...

Your varchar is to small for the data you are putting into it, so it is only taking the first 8 characters and then trying to convert that to a...

Scott Arendt (7/15/2013)

---

No laptop at work and I don't really want one either. Without one, I am free to go home without carrying a laptop and free to go...

david.wright-948385 (7/15/2013)

---

belowery (7/12/2013)

---

That's one of the things I think about when I do get frustrated and think of leaving. I know I won't get that from the start any where...

Here is what I've said in another post:

I've worked for the same place now for over 22 years and the philosophy here has always been your earned the vacation so...

I like that answer, thanks for sharing. I know some may find that logic hard to follow, at least some that I know. 🙂 We have always used...

My process is set to move 3 files between DB2 and SQLserver. The first two run fine, smaller data, the third fails. These run one at a time...

We have two more servers for me to check this on, out INT and production. I set this job up on each and each ran without errors. There...