I'm not sure if it would be difficult, but I think it would be worthwhile to also list whether the FK features enforcement and what it's delete and update rules...

OK, that's exactly what I wanted. Now, how to streamline this SQL (note the redundant select statements...) Using Project ID 0355 for testing...

begin transaction

delete tblWorkOrders

from tblWorkOrders wo

where wo.projectid=03555

and not exists...

Take a look at the Microsoft free tool called "Microsoft SQL Server Migration Assistant. I used it for a year grooming my Access backend database for conversion to SQL Server....

Gail, I don't know what the problem was. It seems to have gone away when I ran the backup successfully. As I said, that step includes a "reorganize index" step,...

I apologize for my "dual-threaded" post. What I thought was a T-SQL error appears to have been corrupted indices or some other odd corruption.

...I ran the backup plan once...

I apologize to all for my poor forum etiquette. I thought my problem was T-SQL related. I was wrong, and my query's poor performance seems to have a DB issue....

Capture.png shows the failed Backup plan.

DBCC Checkdb, etc fails "Incorrect Syntax near " my database name (I substituted the name...CPASD)

"Incorrect syntax near the keyword 'with'. If this statement is a...

My backup failed last night. I can't decipher the log message. Can you help? Seems to be the Master DB.

essage

Executed as user: WINNTDOM\sqlserveragent. ...2100.60 for 32-bit Copyright (C) Microsoft...

OK, I ran the query on a "shadow" database (to avoid impacting my online users...) and it ran correctly and in five seconds. So, there must be some other issue....

OK, here's the query:

SELECT

PR.ProjectNbr

, PR.ProjectDescription

, PR.CapitalExpense

, PR.ProjectCoord

...

Not sure what "Cartesians" are (same as cross-product?), but I don't have nulls. I set a default value and prohibit nulls on these and many other fields where null would...

Kevin, the table build scripts for these four tables are probably 200 lines long, containing columns and foreign keys that are not relevant, and may be confidential. I know that...

I bludgeoned this to death with a subquery that returns the correct results as follows:

SELECT M.BoMWOID, m1.BoMTotMaterialEstimate,

...

OK, I'm an idiot. My original SQL code works. When I seeded the WO Error table with (honestly, only 2, repeated) rows, I inserted a TimesheetID that I had earlier...

Yeah, the app has 116 separate tables, all fully normalized, so there are lots of foreign keys all about. Also, they were migrated using SSMA, so they're very unwieldy in...