Archive | SQL Server RSS feed for this section
binoculars

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

Read more
Dynamics GP, FRx, Management Reporter, SQL Server
, , , ,
turn the gears

Getting the name of a month from the month number in SQL Server

May 23, 2011 by Victoria Yudin 15 Comments

I was creating a SmartList for a customer recently and was using the GL11110 and GL11111 views in GP for monthly summaries of P&L accounts, but wanted to show the month names instead of period ID’s to make it a bit more user-friendly. I could have linked to the fiscal period setup table to get the period names, but [...]

Read more
GP Reports code, SQL coding, SQL Server
,
SQL Server Poll Results

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

Read more
SQL Server
SQL Server Poll Results

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

Read more
SQL Server
,

How to find all SQL tables with a column name

April 23, 2010 by Victoria Yudin 4 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 more
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, [...]

Read more
GP Reports code, SQL coding, SQL Server
,
question mark

Why support only part of a solution on SQL Server 2008?

February 3, 2009 by Victoria Yudin 30 Comments

This is something that came up as I was reviewing posts in the FRx newsgroup and talking to customers about GP upgrades.  I wanted to rant about it a little and see what others thought.  Maybe I am over-reacting? Dynamics GP 10.0 is supported on SQL Server 2008.  However, FRx Reporter 6.7 is only compatible [...]

Read more
Dynamics GP, FRx, GP 10.0, 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 [...]

Read more
Dynamics GP, FRx, SQL Server
, , , ,

When does my SQL Server support end?

October 29, 2008 by Victoria Yudin 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 more
SQL Server
, ,

SQL Server – how to get date differences

October 27, 2008 by Victoria Yudin 6 Comments

Often, when writing a report, we need to calculate the difference between two dates or the difference between a date and today. For example – how old is an invoice? How many days overdue is an invoice? Below is some SQL code that will help. First, if you need to dynamically get the current date [...]

Read more
GP Reports code, GP SQL scripts, SQL coding, SQL Server
,

What version of SQL Server am I running?

October 5, 2008 by Victoria Yudin 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.00 10.00.4000.00 10.00.5500.00 2008 R2 10.50.1600.1  10.50.2500.0 2012 11.00.2100.60 I have started [...]

Read more
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 [...]

Read more
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 [...]

Read more
Dynamics GP, SQL Server
, ,

Follow

Get every new post delivered to your Inbox.

Join 486 other followers