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

...

I would also change your autogrowth to grow by a set size each time. Growing by 10% means each time it grows, it will grow by 10% of its...

Peter,

I just took the time to read your article above. I wish I had know about it as I was doing my article, I would have put a...