Uncategorized
Fastest way to split delimited string in SQL Server
Source : http://www.sqlservercentral.com
/*
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
SET NOCOUNT ON;
SELECT [Value] FROM [dbo].[split_delimited_string]
(‘1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20′,’||’)
WHERE Value IN (1,2,3,4,5,6,7,8,9,20)
SELECT [Value] FROM [dbo].[split_delimited_string]
(‘1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20′,’;’)
SET STATISTICS IO OFF;
SET STATISTICS TIME OFF;
SET NOCOUNT OFF;
*/
CREATE FUNCTION [split_delimited_string]
(
@str NVARCHAR(MAX),
@sep NVARCHAR(MAX)
)
RETURNS @value TABLE (Value NVARCHAR(MAX))
AS
BEGIN
DECLARE @xml XML
set @xml = (SELECT CONVERT(XML,'<r>’ + REPLACE(@str,@sep,'</r><r>’) + ‘</r>’))
INSERT INTO @value(Value)
SELECT t.value(‘.’,’NVARCHAR(MAX)’)
FROM @xml.nodes(‘/r’) AS x(t)
RETURN;
END
Microsoft Dynamics GP Extender Discontinuation Announcement
Source : Microsoft
Effective February 1, 2013, the Extender Standard module for Microsoft Dynamics GP (Extender) will no longer be offered by Microsoft and all associated SKUs will be removed from the
Microsoft Dynamics GP price lists.
eOne Solutions (eOne) will continue to support the existing Extender customers. New or existing customers who wish to purchase Extender can purchase them directly from eOne.
Microsoft will not make Microsoft Dynamics GP Extender available on the Microsoft Dynamics GP 2013 price list. Customers will need to work directly with eOne to obtain Extender for
Microsoft Dynamics GP 2013. Starting February 1, 2013, Microsoft Dynamics GP customers who previously obtained licenses to Extender via the Microsoft Dynamics GP price list will
receive a reduction in the Protected List Price and will not be charged Business Ready Enhancement Plan (BREP) fees for Extender on their next BREP renewal date.
The license keys for these modules will remain on existing customers’ accounts, allowing the continued use of the modules.
This announcement provides partners with the 120-days’ notice required pursuant to the Solution Provider Agreement (SPA).
For more info on the same click here
Microsoft Dynamics GP 2013 Web Client Overview
As GP 2013 introduced with web client on its cards, which is a thin client and enables the below features
- Browser delivered Dynamics GP
- Leverage Silverlight and .Net
- Logic still remains with Dexterity
- Most of the ISV Products compatible.
- Secure Connection
- Gives customer greater choice and flexibility
- Hosting GP got easier and more cost effective
Below are some useful links on the topic
Dynamics Management Reporter
Management Reporter is a specialized financial reporting solution that allows users to create powerful reports in minutes. This application allows executives, managers, and front-line employees to gain access to the information they need when they need it and where they need it. There are 3 basic building blocks in Management Reporter.
The first building block is called a row definition. A row definition defines the descriptive lines (for example, sales or sales returns) on a report. It also lists the account codes or dimensions that contain the values for each line item and includes row formatting and calculations.1
The second building block is called a column definition. 1 A column definition defines the time period to use when extracting data from the financial data source. It also includes column formatting and calculations.
The third building block is called a reporting tree definition. A reporting tree definition is similar to an organizational chart. It contains individual reporting units that represent each box in the chart. These units can be either individual departments from the financial data or higher-level units that summarize data from other reporting units.
Together these three building blocks give users the flexibility to define a virtually unlimited number of reports to meet their business needs. The report definition process is designed in such a way that the average end user can get access to the critical business information they need quickly and easily.
Another feature built into Management Reporter that simplifies the report creation process is the Report Wizard. The Report Wizard gives you the choice between creating one of five different financial reports including a balance sheet, three types of income statements and a trial balance.
Dynamics AX / NAV / GP / SL
AX (formerly Axapta)
This is properly Microsoft’s best product toward the midsize to enterprise level company. It offers many of the enterprise level features, known from bigger packages. It also has strong manufacturing and distribution features. A good solution for a streamlined/centralized smaller enterprise active in many countries. The con about this package is that the projects (just as with other bigger products) often are getting rather heavy and expensive.
NAV (formerly Navision)
The strength of NAV is its usability and rapid development environment. Microsoft primary target this product toward the midsize segment with 20 to 200 users, but I know of many companies with many more users (up to 1000 users). It’s also a very good product for international corporations with many subsidiaries in many countries, due to the rapid development and implementations. Good for practically all types of businesses. The cons of this product is properly that it’s base application is not as strong as AX and it’s SQL implementation is not as good as it could be (but it gets better for each release).
GP (formerly Great Plains)
Another product with nice look and great features with loads of scope on customization, as it used to be one of Navision’s biggest competitors on the US market and basically targets the same businesses (midmarket). And even today, you don’t find it in many other countries than USA. It’s being told that it’s general ledger module is one of the best. The con of this product is primary that you don’t find it strong in some modules.
SL (formerly Solomon)
Personally I heard about this product many years ago as an financial application, but I wasn’t really too impressed. Today this package has been redesigned and is being focused toward smaller and midsize companies in the project management, service and distribution industry. Like GP the cons is that you primary find this product in the USA and week in some modules.
Some Handy Scripts
1) SQL Procedure of search phrase on all Database
2) Backup All Database
3) Get inventory items with positive quantity-on-hand with latest corresponding invoice.
SQL Scripts
1) SQL Procedure of search phrase on all Database
2) Backup All Database
3) Get inventory items with positive quantity-on-hand with latest corresponding invoice.
Download Articles & Tools
Articles & Tools
GP
- Great Plains® Architecture
- Microsoft Dynamics GP 2010 New Features
- Microsoft GP Inventory Year End Process
AX
- Microsoft Dynamics AX 2009 What’s New
- Microsoft Dynamics AX 2009 Keyboard Shortcuts
- Microsoft Dynamics AX 2009 Development With Visual Studio .Net
Dynamics Tips 