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

You don't necessarily need a unique constraint... how else would you have dupes?  But you do need to identify what you want to be unique when the dupes are removed. ...

Look for cursors, while loops, and views of views to start with.  Also look for tables with no primary keys.  The least expensive way to find this is to write...