Viewing 15 posts - 3,166 through 3,180 (of 3,738 total)
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451#tab3
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 3:44 pm
Awesome and you came up with the code on your own!
Please post the solution.
Regards,
Welsh
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 3:19 pm
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?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 2:40 pm
It sounds as if the backup that you are using to restore the filegroup is corrupt.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 2:30 pm
Don't you really want to group Division & Department and then list the EmpId, Sum of the Salary, and a calulated Percentage?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 2:04 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 1:45 pm
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 1:10 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 1:06 pm
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 12:57 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 12:28 pm
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?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 12:18 pm
DECLARE @err int
SELECT @err = @@error
IF @err <> 0
PRINT '@err is ' + ltrim(str(@err)) + '.'
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 11:57 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 11:52 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 11:45 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 11:36 am
Viewing 15 posts - 3,166 through 3,180 (of 3,738 total)