Tag: sql

SQL view for sales quantities by item by year

| 01/23/2012 | 0 Comments

Even since I published my view for sales by item by year I started receiving requests for the same type of view showing quantities instead of amounts.

Continue Reading

How to configure SQL Profile Tracing using the Support Debugging Tool

| 01/16/2012 | 0 Comments

Following the release of Build 16 of the Support Debugging Tool , I want to take you through how to configure the SQL Profile Tracing functionality so you can gain the benefits of this awesome feature. The Support Debugging Tool has always been able to capture a DEXSQL.LOG of the communication between the Dynamics GP Application and the SQL Server, but when a Stored Procedure is called on the SQL Server, we lose visibility of what is actually happening at the SQL Server. Now with SQL Profile Tracing we can see exactly what is happening at the server as well and match this information with other logs we have at the user interface, Dexterity application and SQL Server levels.

Continue Reading

Support Debugging Tool Build 16 released

| 01/05/2012 | 0 Comments

A week into the New Year and no posts…. what’s happening

Continue Reading

SQL view for vendor yearly totals in Dynamics GP

| 01/04/2012 | 0 Comments

There has been a lot of talk lately about the year end close Payables and Receivables. I feel like I have spent the last week or two justifying my reasoning for not needing to perform the year end close for Payables and Receivables to many of my customers and blog readers. (For more on this, please see my Year end close in Dynamics GP blog post .) My main reasoning has always been that the only thing accomplished by the year end close is updating the ‘amounts since last close’ year-to-date and last-year totals and since that can be easily (and maybe even better?) accomplished by a custom report, why waste time on the year end close for these modules in GP

Continue Reading

Error Code 2337 When Installing Microsoft SQL Server … – azurecurve

| 12/21/2011 | 0 Comments
Error Code 2337 When Installing Microsoft SQL Server … – azurecurve

One Response to Error Code 2337 When Installing Microsoft SQL Server Into A Virtual Machine. Pingback: Error Code 2337 When Installing Microsoft SQL Server Into A Virtual Machine | azurecurve – DynamicAccounting.net ..

Continue Reading

Quick Tip: Passing Date and Time Variables to SQL Server

| 12/16/2011 | 0 Comments

As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server , I wanted to discuss the related topic about passing of date and time variables.

Continue Reading

Quick Tip: Passing Variables to SQL Server

| 12/15/2011 | 0 Comments

Wow, the week is almost over and I am yet to post something.

Continue Reading