Dear All thanks for the help and guidance. Just to advise you of what I ended up doing. As some of the proposed solution were too complicated. For me anyway...

Posted to the wrong thread, therefore deleted 🙂

Many thanks guys. I reviewd my code following your comments and now it is like this

declare @StartDate datetime --first day of a period, has to be calculated and exclude...

I just want to thank you all. This issue was resolved. I restored the same database with a different name under the same instance about a month ago, this is...

No it is nol longer running.

Thanks

Thanks for the reply

umasingh I tried using the wizard but it fails every time. It keeps failing the validation and saying that record_Id not allowed to be null. something...

Thanks Guys the following query works as needed. 🙂

declare @d datetime --input parameter for the procedure

set @d=(SELECT DATEADD(day, DATEDIFF(day, 0, getdate()), 0)) -- get current date

declare @StartDate...

Hi again and again 🙂

Thanks ModestyBlaise84, I combined your sample query with toddasd's sample query and the result was positive. I have the needed data. but I just need...

henners72 (5/11/2011)

---

Hey, I was just providing an example of the code you could use to select this information, as in teach a man to fish......refining the logic should be up...

ModestyBlaise84 No problems thanks for the help, Now I know it is not that simple :-), but sometimes we humans make the wrong assumptions.

Thanks you everyone for the feedback...

ModestyBlaise84 (5/10/2011)

---

Have to notice that these children will not get a chance to improve 😉

The query above will include all kids that were absent 3 or more days, regardless the...

henners72 thanks for the help. I just need to clarify something please, why do I need to create another table. Your assumption was right; the data is entered on daily...

Hi Everyone:

Wooh Found the problem :). thought I'll post in case someone having a similar problem. I discovered the System Admin was running a backup job every night at...

I tried running the following query:

select * from sys.backup_devices

the query returns a blank table.

Best regards

Hi:

We do use Symantec Backup Exec, however we don't have an agent for SQL backup. The system admin is only backing up backup files created by SQL on backup tape....