I know what you mean... It's only when they live up to the name of "BSOFH" and they've got that control thing going on... or, they're just plain old stupid.

I gotta agree with THAT!  Between a tally table (you guys call it a numbers table) and/or a date table (mine are combined into one which is why I called...

Cool... Thanks Noeld.  It's been so long since I've used a trusted connection, I almost forgot they existed.

I'll probably keep using linked servers, though,...

One of the things I don't like about open row sets is the login information is in the query... and, no, I prefer not to encrypt queries especially on development...

test

Reddy,

Thanks for the advice especially about the Repair_Allow_Data_Loss option... I'll remove that holding it for the very last stab.

Understood about the other stuff... I did try attaching in EM, using...

Awesome, ain't it? Most good SQL Developers would be disappointed if that took more than a handfull of milli-seconds regardless of how many...

All good points, Rudy... I'm used to good DBA's that take proper care of those things, so I tend to forget about them.  My big problem has been that most...

Frank and Chris,

Because the 1st of January, 1900 was a Monday, this also works regardless of the setting of DateFirst.

DECLARE @Year    CHAR(4)

DECLARE @ISOWeek VARCHAR(2)

    SET...

Nice article, Chris... excellent links, as well.

Thanks Chris,

I'll take a look.

Please tell me what version of Oracle has a FROM clause for UPDATEs?

If running from a scheduled batch job in a CMD window, convert the script to a stored proc, call it from OSQL, and use (> ) or the (-o) option...

Frank,

I'm not familiar with the rules for ISO Weeks... have heard that the first week of a year must have 4 or more days to qualify as week one or...

Wrap the whole SELECT/UNION/SELECT in parenthesis, give it an alias like a table, and us it in the FROM clause of yet another SELECT/GROUP BY.  By the way, SUM(QtyScanned)*0 could...