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

This works so nice that I thought I'd put it out here now in case someone else needs it right away and then write the article.  Man, did I get...

Never mind folks... I got it...  it's a bit convaluted but I'll clean up what I did in the form of step by step instructions and post it... hmmm... maybe an...

Yeah, I didn't say that quite right... BOL has a better way of saying what I so poorly said...

Each time an instance of SQL Server starts, it recovers each database,...

"I want to fetch code from each file (in Query Analyzer) and then do as you said i.e. execute the code.

But how do i loop through a dos directory in...

...or do you mean you want to execute them in a DOS batch run (ie. filename.BAT)?  If you want to execute the files from there, then you would use OSQL...

Here's the calculation you requested... it's quite a bit more complicated that when weekends are Sat/Sun because SQL Server's "Week" datepart always breaks between those two days.  And, DateFirst has...

>is it okay to clear transaction log in mssql server ? 

Yes... unless the server crashed and you need to roll some data forward.

>if it's ok, how to clear transaction...

Either way, there have been problems with SP_OA and memory leaks of one form or another.  My recommendation is to test it for memory leaks before you put it into production...

A version without a correlated sub-query... but only if you can guarantee that the date you use is a month end date  and that all of the DateMonthEnd dates are...