Steve can move it, but there's no real need to. Edit the original post, add something about it being SQL 2000 right at the beginning. That'll make it...

Twice, I took a custom-built database for a custom-built application and decided to rebuild it from the ground up. Once, because changes in the business would be better served...

I have to ask, why even do the join? Maybe I'm missing something, but the only thing I see being pulled from the join table is the join column,...

Good article.

I've used Cross and Outer Apply a few times very successfully. They work better with sub-queries than with UDFs. Even a single-select UDF has a performance hit...

Bob Hovious (2/26/2009)

I just have to ask, how much of your coding efforts are spent...

I thought the way to defeat COBOLDs was to ask them about five-digit years. Causes them to hyperventilate themselves into a coma, or something.

I don't think...

SMS = Texting. Yep.

You're welcome.

Not sure where to take it from there. I've never had a problem with getting it to connect to the service I needed unless there was a security issue...

Personally, I think the people who insist on upper-case code should be forced to read all-caps books. Ten minutes of that should cure them!

I've found SSIS is great for files with a relative degree of consistency, and has major problems with files that have been mangled by people who don't have the faintest...

Oh, I saw the part where you said you were wrong. I just thought I'd rub it in a bit, since we've had this discussion before about speed sometimes...

Gotta agree with you on the uppercase thing.

I'm having to use it at work these days, because of company standards, but I find it makes the code harder to read.

I think this will work. Can't test it, but I think it will.

SELECT

BL_TRUCK_BOL_TRAILERS.bol_no,

BL_TRUCK_BOL_TRAILERS.rev_no,

BL_TRUCK_BOL_TRAILERS.trailer_id,

BL_TRUCK_BOL_COMMODITY.comm_code,

BL_TRUCK_BOL_DEST_COMM.prod_storage_id,

BL_TRUCK_BOL_COMMODITY.comm_um,

BL_TRUCK_BOL_DEST_COMM_ORDER.quantity,

BL_TRUCK_BOL_COMMODITY.end_scale_wt,

BL_TRUCK_BOL_COMMODITY.quantity,

(select...