Gail, I see in the backup that he is not using WITH INIT. Does this mean that by default the backups are being appended?

Can you provide a sample of your data set, not the report. Also, what is your report currently grouped on?

Ok, well first I see that the sample data you gave is not looking correct. You have 2 people, 4 dates, and 2 sales numbers. I assume it looks...

Shree-903371 (1/24/2012)

---

Hello,

I need total based on a group. For example I have

Salesperson ...

Rob-350472 (1/24/2012)

---

I've changed the service to from network service to a local admin account, I've then added this local admin account into SQL Logins and given it the sysadmin role,...

Marios Philippopoulos (1/24/2012)

---

Sorry, I don't follow,...

Side note... Current is a reserved SQL keyword. If you must use it, put it in []. However, I suggest picking something else.

As you can see, my query works. In order for us to help you, please post the ddl of the table you are running this on, some sample data,...

Is EXECUTE AS not an option?

http://msdn.microsoft.com/en-us/library/ms188354.aspx

As long as it allows NULLs, yes.

Looks fine to me:

use tempdb

CREATE TABLE #temp (id int identity(1,1), value money)

INSERT INTO #temp

SELECT 2.50

UNION ALL

SELECT 4.00

UNION ALL

SELECT 500.00

SELECT SUM(CASE

WHEN id <= 2 THEN value

ELSE 0

END) AS sum_value

FROM #temp

DROP TABLE...

I would ask why they are shrinking the log when the databases are in simple recovery mode. Start there...

http://msdn.microsoft.com/en-us/library/ms189275.aspx

Try this...

SELECT CAST(CAST(GETDATE() AS DATE) AS DATETIME)

This will 0 out the date. If you want the actual date only, then just do this:

SELECT CAST(GETDATE() AS DATE)

NOTE: This will not...

Michael L John (1/23/2012)

---

Bron Tamulis (1/20/2012)

---

Leo - Thanks for the reply.

I know DYNSA is not an orphaned user. DYNSA user is automatically created when Great Plains is installed on a...

I assume you are doing what I used to do for this: Take backup of productionCompany database, restore to test database, run replace script to replace the company name.

The...