No use whatsoever? I wouldn't say that. I suppose the designers' idea was that every level could reach the end where it would decide either to commit or raise an...

The number of books I read varies so much. One year I may only read (or parse) a few technical books and the next I may read 20-30 novels and...

Well, all you've done is convert an execute statement that's in a loop to a series of execute statements -- which seems to me to be largely a distinction without...

That's what it's there for. I just wish more OPs would include it so we could all be working with...

I disagree wholeheartedly. The much...

Partitioning is "DBA stuff" so that is outside his scope.

Here is another solution. INTERSECT is needed when merging data from queries executed against different...

Here is one way. Create a "master" shape table to reference each individual shape and a separate shape table for each shape. This is done in a way so that...

Then go to work for the Government.

A coworker left to get a job with the State of AZ...

Matt Miller (3/6/2009)

---

With all due respect - what we choose to value above everything else is a cultural thing. Irish does have a point that in our American culture,...

In a...

It's not a question of necessity. It just is. The meaning...

•Retraining - Just about every company I've worked for in the last 25 years has encouraged and paid for (at least heavily supplemented) the costs involved. What more could we...

...or properly normalize the tables. You'd be amazed at how simple queries become when the tables are modeled correctly. It's kinda, like, y-know, the whole point of data modeling. 😀

Part of the problem is that you don't have nulls where you do need them. You want to have a self-referential chain of departments and sub-departments. That is fine, but...

I have no idea what you are trying to accomplish. If the proc returns an integer value, you can store it into an integer variable similar to calling a function.

create...