http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451#tab3

Awesome and you came up with the code on your own!

Please post the solution.

Regards,

Welsh

What is the formula for percentage?

Don't you want your records to be Grouped By and Ordered by Division & Department so that they are aggregated and Sorted in that order?

It sounds as if the backup that you are using to restore the filegroup is corrupt.

Don't you really want to group Division & Department and then list the EmpId, Sum of the Salary, and a calulated Percentage?

You just can't say that you are only ever going to have one user for any application that you develop. That is a new approach to security that I have...

Have you ever worked with ASP.NET?

If you can't answer my question then I'm not going to provide you with any additional information.

I would first start out by comparing the schema in your tables against the Great Plains Tables (Map the Columns to the tables and the columns).

Then look at the data...

I was trying to find out if your security model was based on a web application or a windows application.

I had a reason for asking this question.

You have to map the data from the data that you have in your SQL Server Database to the Tables in Great Plains (GP).

You need to make sure that you...

Yes, you can load into Dynamics. I did it 8-9 years ago, not a problem.

So are you asking how to do it, as in create a SSIS Package or what?

DECLARE @err int

SELECT @err = @@error

IF @err <> 0

PRINT '@err is ' + ltrim(str(@err)) + '.'

So you want to load the data in the Excel Document into the Tables that you have defined?

Is that correct?

Then you want to "integrate" into a CRM. What CRM you...

Your SELECT Statement is the cause of the error. Replace with a print statement to make it easier.

Also you want to assign the @@ERROR to a variable @ERROR and...

Response: There would be multiple people that use the system, but the actual connections would be though either one user ID or one per application. By doing this, we do...