Introduction: This blog post is written by my friend and colleague Mickie Stamm. Mickie is a fabulous Dexterity, SQL and application developer and is one of the great minds behind GP Reports Viewer. By Mickie Stamm: In the last GP Reports Viewer newsletter I wrote about using rectangles as containers in SQL Server Reporting Services […]
Read more
Tag Archives: SQL Server
Finding resources
May 12, 2012 
5 Comments
Almost on a daily basis I find myself looking for things like system requirements, end of support dates, build numbers and downloads for the various products that I work with. Even though search engines have greatly improved over the last few years, I still often struggle to find this information. While I consider myself to […]
Read more Results of SQL Server poll
February 8, 2011 0 Comments
It has been about a month and 119 people voted, so I wanted to share the results of my SQL Server poll. I asked what version of SQL Server my readers were using for their Dynamics GP and here are the results: While I am glad to see that only a few voters (5%) are on […]
Read more SQL Server poll
January 14, 2011 5 Comments
I am starting to see articles and blog posts about Microsoft SQL Server 2011 everywhere, so I thought I would poll my readers to ask versions of SQL Server you are using. The poll is below: Once I have some results back, I will post an update. In the meantime, keep in mind that SQL Server […]
Read more Dynamics GP 2010 implementation book coming soon
November 15, 2010 21 Comments
My book, Microsoft Dynamics GP 2010 Implementation, is off to the publishing house and should be ready to ship soon. While the primary goal of the book is to help with new implementations of GP in small to mid-size companies, there’s something in it for everyone. Just to highlight part of the content, this book has step-by-step […]
Read more Coding specific dates in SQL Server
September 13, 2010 2 Comments
Quite often when writing reports I need to write a formula to calculate dates. Dates are not very straightforward to code in SQL Server, and I have started keeping a list of various formulas so that I do not have to re-write the code every time. I have previously posted some code on calculating date differences in SQL, […]
Read moreHow to find all SQL tables with a column name
April 23, 2010 5 Comments
Often I need to find all the tables in Dynamics GP that have a particular column or search for all columns where I only have a partial column name. Over the years I have seen lots of different code to accomplish this, so this is nothing new. But I am asked about this enough that […]
Read moreSearching for strings in SQL Server using LIKE
March 2, 2009 7 Comments
Many times when searching for data in SQL Server we need to search for strings and use wild cards. One common wild card is %. As an example, I am going to use the Customer Master table (RM00101) in the Dynamics GP sample company, Fabrikam, Inc. If I want to all customers with ‘USA’ in the Class ID, […]
Read moreNew page with resources
December 22, 2008 2 Comments
I have published a new page called Resources that has links to information I am either frequently looking up or I am being asked for routinely. Stuff like Dynamics GP system requirements, printer compatibility lists, how to translate a build number in GP, FRx or SQL Server to a specific service pack, when support for various versions […]
Read moreWhen does my SQL Server support end?
October 29, 2008 10 Comments
Did you know that mainstream support for SQL 2000 ended in April of 2008? Here is a list of the SQL versions and the relevant release and support end dates: SQL Server Version Release Date End of Mainstream Support End of Extended Support Link SQL 7 Mar 01 1999 Dec 31 2005 Jan 11 2011 […]
Read moreWhat version of SQL Server am I running?
October 5, 2008 3 Comments
Here is a summary list of the major releases and service packs for Microsoft SQL Server: SQL Server RTM SP 1 SP 2 SP 3 / 3a SP 4 2000 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039 2005 9.00.1399 9.00.2047 9.00.3042 9.00.4035 9.00.5000 2008 10.00.1600.22 10.00.2531 10.00.4000 10.00.5500 2008 R2 10.50.1600.1 10.50.2500 10.50.4000 2012 11.00.2100.60 11.00.3000 I […]
Read moreSQL Server 2008 Videos
October 2, 2008 2 Comments
I just came across this very un-Microsoft looking Microsoft webiste for SQL Server. There are a number of videos here geared towards different audiences. I haven’t watched them all, but I did find Scott Konersmann’s video about upgrading to SQL 2008 very interesting. And some of the For Fun videos are pretty funny – especially “It […]
Read moreLimitations on data in GP?
September 23, 2008 0 Comments
One of the benefits of Dynamics GP being on Microsoft SQL Server is that there are virtually no limitations on the number of entries of a particular type. But the question does come up a lot. What’s the maximum number of customers or customer addresses, or sales transactions, or line items can I have in GP […]
Read moreMy Book
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view for Payables payment apply detail in GP
-
SQL view for all posted GL transactions in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for sales by item by month
-
Assign sequential numbers in SQL Server
-
SQL view for current Receivables aging detail in Dynamics GP
-
SQL view for current Payables aging detail in Dynamics GP
-
Changing part of a string in SQL Server using REPLACE
-
SQL view for sales quantities by item by site by year
-
SQL view for Fixed Allocation Accounts in Dynamics GP
-
Happy New Year – 2013
-
How to add a sparkline to a report in SSRS
-
Voiding a partially applied Payables transaction in Dynamics GP
-
Big announcement for Microsoft Dynamics GP’s Extender module
-
Victoria Yudin: Hi Rolan, There is no way to 'edit' this once pos...
-
Rolan Hinayon: Hi Victoria I am newbie here but it feels li...
-
-
Calvin: Thanks Victoria, that worked. I gave permissions t...
-
-
-
-
lynbarr: FYI, MR 2012 RU5 = 2.1.1037.15...
-
-
Carrie John: This process works great when it's a non-PO transa...
