Have you run a dbcc CheckDB on the database? Read BOL first, as you only want to see if there are any errors, you don't necessarily want to fix...

To make sure anyone who helps you is on the same page a little more info is required. If you could provide the DDL (create statement for the table(s)),...

Have check the system while this query is running to see if there are any blocked processes?

😎

Start with this and do a lot of testing. You may need to tweak it as I did not do a lot of testing so its accuracy may vary.

declare...

Now, how would you like to see the result returned? If it is a single number value, how would you distinguish between 1 day, 1 week, 1 month, 1...

Peggy Rowles (6/30/2008)

---

The posted codes work fine for full years, but I have been trying to find good SQL code that will calculate down to days if needed (for babies)....

Here is what I think may have happened, and it will require you to run a full backup to restart your backup chain. It sounds like the recovery model...

What recovery model is the database using?

😎

If Pkg_Per is defined like this: Pkg_Per decimal,

Then I know the problem. The problem is the default definition for decimal, if not explicitly defined, is like defining as (18,0)...

Doesn't tell me much, decimal what; decimal(10,3), decimal(3,2)...

😎

Also, how are these defined: Installed_Clients Targetable_Clients ?

😎

How is this column Pkg_Per defined in the database?

😎

There looks to be a problem with this query:

UPDATE dbo.tblOpenDaily

SET Who = 'Result'

(SELECT TOP (100) PERCENT dbo.tblOpenDaily.[Entered Date]

FROM ...

Have you tried attaching the existing model.mdf and model.ldf files since you say the exist in the data directory with the other system database files.

😎

Not exactly sure how SQL Server is interpreting your query, but you might want something more like this:

UPDATE dbo.tblA

SET Answer = 'Result'

FROM dbo.tblA INNER JOIN

...