Why don't you just right click on the table name in SSMS in the object explorer and do 'Script table as' then select 'SELECT to'. This will do the...

As a developer I have to disagree. 🙁 Where...

Craig-315134 (8/21/2013)

---

The author wrote:

... I sometimes think that an investment in developer education would quickly erase any productivity losses ...

Education is always a good thing, but it applies all around,...

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