Invoice Key 159021 returns 1 invoice row, Invoice expense and Invoice Tax which have 0 rows with invoice key 159021 where invoice key is a foreign key in both those...

when no rows are returned for invoice expense and invoice tax, I still need a row to be returned with the invoice key from invoice and a count of zero

Have tried ISNULL , doesn't work, still returns null

Still doesn't fix the issue when run from SQL Agent, which has the correct permissions, log files say everything ran OK, parent and child, yet a table is not being...

Scratch that last post. If run from SQL Agent it runs successfully without updating the table needed. When run in design mode, it fails on an active script...

Yes it shows the child has completed and the stored procedure, Execute SQL Task, has completed successfully, yet it does not do the update to table within that stored procedure....

I pasted the error message into Google. A person in Australia had the same problem, the fix is to delete MS Office 2003 Web components. After deleting that and...

The log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100608_162758\OWC11_Cpu32_1.log

is a very large file, however towards the bottom, I think it's saying the failure is due to Windows Office 2003 Web...

Well that didn't work. Everything installed except the "Services", they all failed. This is the summary of the text file. I says to go to log files, which I...

The first error screen is the Service Accounts, this install is Developer Edition on a laptop, for learning purposes only. I am the sole admin.

The Integration Services is using >...

Yes I was talking about Reporting, Integration and Analysis Services. Removed SS2008 and then the native client. Attempting another install now.

The database engine installs just fine, so does everything else, just not the services. I'm thinking the services are not installing due to the UID and PWD, but not...

Well, that's part of the problem too. None of the services, Report, Integration, Analysis install properly, they all fail. I've tried numerous installs, can get everything else...

The workbook is not open and I have admin rights to the computer. It is the strangest thing! I finally got it to work on my XP machine,...

I think I've found a solution....in Visual Studio, click on Tools, then Options. Click on Projects and Solutions. Under user project templates, change the path to this

C:\Program Files\Microsoft...