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

I found it and I was correct...

They first found memory leaks in the SP_OA procs in SQL Server 6.5 and supposedly fixed it... see the following URL:

http://support.microsoft.com/kb/151601/EN-US

I guess...

It sounds like you may need to build a "Calendar Table".  Lot's of folks have wriiten about their construction and use.  I'd also recommend taking a peek at the following...

Jon,

What kind of VB functionality are you looking to do?

IF OBJECT_ID('TempDB..#Results') IS NOT NULL

DROP TABLE #Results

SELECT IDENTITY(INT,1,1) AS RowNum,

  ...other columns as you need...

INTO #Results

FROM ...your tables and joins...

ORDER BY ...the order you...