Tag Archives: SQL Server

Updating Dynamics GP data directly in SQL

January 17, 2017 by Victoria Yudin 20 Comments

I would like to start by saying that I do not normally advocate updating Dynamics GP data directly in SQL Server. Most of the things you need to do should be handled either inside the Dynamics GP application or with integration tools like Integration Manager or eConnect. This is especially true of transactional data and […]

Continue reading →
Dynamics GP, SQL Server
, ,

SQL stored procedure to search an entire database

July 22, 2013 by Victoria Yudin 1 Comment

I don’t often re-post things from other blogs, but this is just too good not to share. David Musgrave recently published an update to his spSearchOnAllDB stored procedure on his blog, Developing for Dynamics GP. Simply run the script to create the stored procedure and you can search all the tables in a database for a […]

Continue reading →
SQL Server
,

How to add a sparkline to a report in SSRS

November 27, 2012 by Victoria Yudin 3 Comments

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 […]

Continue reading →
Dynamics GP, GP Reports Viewer, SSRS
, , ,

Finding resources

May 12, 2012 by Victoria Yudin 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 […]

Continue reading →
Dynamics GP, FRx, Management Reporter, SQL Server
, , ,

Results of SQL Server poll

February 8, 2011 by Victoria Yudin 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 […]

Continue reading →
SQL Server

SQL Server poll

January 14, 2011 by Victoria Yudin 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 […]

Continue reading →
SQL Server
,

Dynamics GP 2010 implementation book coming soon

November 15, 2010 by Victoria Yudin 22 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 […]

Continue reading →
Dynamics GP, GP 2010
, , , ,

Coding specific dates in SQL Server

September 13, 2010 by Victoria Yudin 3 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, […]

Continue reading →
GP Reports code, SQL coding
, ,

How to find all SQL tables with a column name

April 23, 2010 by Victoria Yudin 8 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 […]

Continue reading →
GP Reports code, SQL coding, SQL Server
,

Searching for strings in SQL Server using LIKE

March 2, 2009 by Victoria Yudin 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, […]

Continue reading →
GP Reports code, SQL coding, SQL Server
,

New page with resources

December 22, 2008 by Victoria Yudin 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 […]

Continue reading →
Dynamics GP, FRx, SQL Server
, , , ,

When does my SQL Server support end?

October 29, 2008 by Victoria Yudin 15 Comments

Did you know that mainstream support for SQL 2012 ended in July of 2017? 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 […]

Continue reading →
SQL Server
, ,

What version of SQL Server am I running?

October 5, 2008 by Victoria Yudin 4 Comments

Here is a summary list of the major releases and service packs for Microsoft SQL Server: SQL 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 10.0.6000.29 2008 R2 10.50.1600.1 10.50.2500 10.50.4000 10.50.6000.34   2012 11.00.2100.60 11.00.3000.0 11.00.5058.0 […]

Continue reading →
SQL Server
,

SQL Server 2008 Videos

October 2, 2008 by Victoria Yudin 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 […]

Continue reading →
Microsoft, SQL Server
,

Limitations on data in GP?

September 23, 2008 by Victoria Yudin 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 […]

Continue reading →
Dynamics GP, SQL Server
, ,