Sergio Lugo (6/30/2008)

---

Hi everyone !

I use this formula:

Age = floor(datediff(day, [DateOfBirth], getdate())/(365.25))

You can also put it in a calculated column.

It works (I think) because one year actually has 365.25 days......

After seeing this error in another forum thread, I have 2 possibilities. One, the recovery model being used has changed on the database. Two, a BACKUP LOG WITH...

Does this help you with getting you where you need to go?

create table #ActiveStatus (

AcctId int,

ActiveStatus bit not null, -- 1 =...

Is this regardless if it also went inactive during that same time (ie does it matter the order of active/inactive)?

😎

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 ?

😎