Chris Howarth (6/2/2009)

---

It continues to amaze me that people don't use Integration Services (to pull data into a central repository) and Reporting Services to assist with tasks of this nature...

Lokesh, the updated article is approved, so the corrections should be visible.

Good job on the article.

Are you using SSMS or something else? I haven't seen anything like this centered. Do the results come back in the grid, or are you using text? I might try...

How are you displaying things? If you are running this in SSMS, it should remove the left spaces and return the data correctly. If you doubt that, have you pasted...

Congratulations, and thanks for the information.

I'd like to whack the Quote button. It gets a little crazy at times.

I edit mine down to just the person I'm quoting.

If that doesn't work, double check server and client tool versions. Sometimes those cause issues of they are different.

I have a few people a year sending me email for refunds for SSWUG. Apparently they get upset when SSWUG links to me.

TheSQLGuru (6/1/2009)

---

Believe it or not Steve I have had not one but TWO hiring managers tell me in the last few months that my rate was significantly LESS than what...

This isn't "locking" a row or cell. a lock is preventing an update from colliding with another, not preventing someone from being able to update. That's a permissions issue.

What you...

Not sure that z: is a network drive. We standardized on z: for our servers years ago as the data drive for local storage. That way we knew it was...

Where is the HTML mangled? I didn't see it in FF3.

I'm not a big fan of dynamic SQL, actually I hate it, but we try to present multiple points of view, and this is not a horrible way to code...

Very interesting. I was expecting to see more complaints about SOX, but maybe I'm not out of touch as a DBA. This law definitely helps DBAS, or anyone that wants...

If you had varchar(max), the procedure might have changed to TEXT when it moved to 2000. You can't use varchar(max) in 2000, and you can't sort, compare, etc. a TEXT...