agbondoc (1/25/2012)

---

Thanks Jared.

You are correct that I am new to this forum and I will read (if time permits) the reference you sent and educate myselt on the "forum standards"....

You could execute this procedure as such...

DECLARE @returnVal INT;

EXEC [dbo].[LitespeedBackupDB] @Dbname = '<database name>', @BackupPath = '<backup path>', @retval = @returnVal OUTPUT;

SELECT @returnVal;

CELKO (1/24/2012)

---

You then ask us to divide these into the foo_types, but we have no rules for that division. We have no idea how many foo_types and if they are...

Did you ever run sp_change_users_login 'auto_fix', '<login>'

I think that the "easiest" way is to run the features discovery from the install disk.

bill.akin (1/24/2012)

---

I am beginning to doubt my knowledge of sql. seems i can not even write a simple query.

select count(member_number), member_time.date

from member_time

where member_time.date >=convert(date,DATEADD(dd,-1,GETDATE())) and member_time.date <=convert(date,dateadd(dd,-7,getdate())

group by...

ramses2nd (1/24/2012)

---

Yes the source table for this data does include a clock in and clock out time but I could not use thoses fields in the calculation since there are...

Just curious... In your sample data are you giving us the entire actual table, or not? My guess is that there is a clock in datetime and a clock...

I think he is...

I had a member of our ops department come in the other day and ask why he couldn't restore a backup he had of the accounting database (for some reason...

What happens when the schema is not dbo?

L' Eomot Inversé (1/24/2012)

---

Lian Pretorius (1/24/2012)

---

dwilliscp (1/24/2012)

---

Thanks for your imput.. they are trying to keep Very small log files. I guess the forecasting software must create batches of large changes,...

What exactly was the issue? You really haven't explained anything here; kind of like saying my computer doesn't work and just leaving it at that 🙂

Can you please post sample...

While we wait for your sample data, you can look at the DATEDIFF or DATEADD functions.

Can you please provide sample data and table DDL in the form of SQL statements. See this article for reference:

http://www.sqlservercentral.com/articles/Best+Practices/61537/