And for those that like CTE:

USE GM_Main -- use your database name here

GO

WITH t1 (AccountNo, RecID) AS

(

SELECT c.ACCOUNTNO...

Here is an example of using my previous example with a "derived table":

SELECT *

FROM (

SELECT c.ACCOUNTNO AS...

OK, if you do return to continue this discussion, consider the following query -- it will return one and only one account number for each "contact" that has at least...

I am EST too.

By the way, what are you using CONTSUPP.country for? In my system, that field retains the balance owed for a customer's particular product. A customer could have...

Your system is similar to mine -- you use "course name", I use "product" -- you have "course codes", I have nearly 200 distinct "product codes".

If you could submit a...

As an alternative to my previous post, this should work too:

SELECT DISTINCT c1.accountno,

c1.contact,

contsupp.contact,

...

I assume this is a GoldMine database. If I understand your system correctly, try this:

SELECT c1.accountno,

c1.contact,

contsupp.contact,

...

Is devstageserverlist.txt or ignorelist.txt "empty"?

NY-SQL DBA (12/27/2011)

---

Thanks Ron for the update.

I changed the file name to parseerrorlog.bat and made the same changes in the script accodingly. i changed back to the names...

NY-SQL DBA (12/27/2011)

---

------------------

The term './parseerrorlog.bat' is not recognized as the name of a cmdlet, function, script file, or operable program. C

heck the spelling of the name, or if a path...

OK... I was able to get "htmlreports.ps1" completely working without errors and proper output (backup and errors html report). My environment is PowerShell 2.0, SQL Server 2005, and Windows 2003...

I did get the PowerShell Host (sqlps) working with SQL Server 2005 on a Windows 2003 Server using PowerShell 2. You have to install a number of the SQL Server...