X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 sql if statements


What’s New in Microsoft SQL Server 2000
SQL Server 2000, the next major release of SQL Server 7, is Microsoft’s SQL 7 release of its database both re-architected and re-written. Microsoft has high

sql if statements  have multiple installations of SQL Server on the same machine. This was previously impossible due to the way NT registry entries were made. This inability in prior versions was a serious problem, since many customers wanted to be able to run a test and a production instance on the same (typically very expensive) machine. Database Maintenance Database Programmability Enhancements: Cascading Referential Integrity: In previous releases of major databases, if an attempt was made to delete or update a key

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » sql if statements

Can Technology Make CFO's and Controller's Jobs More Strategic? (Part 2)


Part 1 of this blog series established that by offloading non-essential and non-value-adding routine tasks to third-party business process outsourcing (BPO) specialists, many human resource (HR) and payroll managers are now able to focus more on strategic and more important tasks of managing talent and human capital of the company. The discussion then went into the possible liberation of chief

sql if statements  stack, starting with Microsoft SQL Server on the back end.  Microsoft Office SharePoint Server (MOSS) is the collaboration platform for customer Web portal and data integration, while business rules are on Microsoft BizTalk Server . Since Corefino’s Triple-C custom technology layer includes the abovementioned cycles of connect, correct, comply, the company is using Web Services  and data extract, transform, and load (ETL ) tools like Informatica . Data is then stored in data marts , where it can Read More

FRx Poised to Permeate Many More General Ledgers Part Two: Market Impact


Since FRx already has integrations built to over forty leading general ledgers (and now a scalable tool kit available to accommodate virtually all others), the idea was for users to leverage the investment they have already made in their GL and to add increased functionality as their needs become more sophisticated.

sql if statements  , which generates Microsoft SQL Server Analysis Services OLAP cubes as an additional method of exporting data from FRx. Last but not least, the product offers currency translation as an add-on component for organizations that might need it. The module allows entries made in the GL's home currency to be translated into specific currencies for reporting purposes. The product also comes in different editions. The FRx 6.5 Desktop edition is best suited for companies that have multiple departments and cost Read More

Is There Much More (Pro)Clarity In Microsoft’s BI Strategy Now? - Part 2


Part 1 of this blog series presented Microsoft’s official position on its recent notable change in business intelligence (BI) product strategy, whereby the company is breaking apart the business performance management (BPM) family of products. To that end, Microsoft will include the monitoring and analytic functionality within Microsoft Office SharePoint Server (MOSS) 2007, while seriously

sql if statements  (e.g., Microsoft Office , SQL Server , and SharePoint) versus making upfront investments in products with less certain returns and much longer paybacks (e.g., PerformancePoint), is a prudent (ahem, performance management-based) strategy that seems to be in tune with the current dire economic realities. Only time will tell whether this decision is in tune with the reported changing habits of BI buyers. Dear readers, what are your views and comments in this regard? If you are existing users of Read More

One Year Later at Deltek: More of the Same (And Then Some More) - Part I


Time and again during my decade or so of covering the enterprise applications market as an industry analyst I have witnessed what difference a year can make. And boy, would 2008 be such a year! A year ago or so, I concluded an in-depth four-part series on Deltek (NASDAQ: PROJ), whose executives were recently happy to tell me that 2008 was not that terrible a year for the company. Quite the

sql if statements  capabilities. It features Microsoft SQL Server Analysis Services (SSAS)   online analytic processing (OLAP ) cubes for Microsoft Excel -based analytics, the ability to produce global and local financial statements, and mobile customer relationship management (CRM ) capabilities. Currently, the most important new development in the Vision world was the Consulting Edition that Deltek released around the time of the Insight 2008 conference . Using the core Vision engine as a base, the edition was a Read More

What Good Is Information If Nobody Sees It?


Keeping detailed historical information is a great idea in theory, but how can it be merged with current data to enable split-second decisions? Two companies partner to solve a significant problem in e-commerce.

sql if statements  Good Is Information If Nobody Sees It? What Good Is Information If Nobody Sees It? D. Geller and M. Reed - June 16, 2000 Event Summary Smith-Gardner builds and sells software products that pull together data from all of a company's operational data channels. They recently announced a suite of products, collectively called Ecometry, which help online retailers collect and manage a wide range of customer and transaction data. The goal is to provide a single view of the customer data. Ecometry is Read More

Infor ION-izes its Open SOA Strategy - Part 1


2010 has certainly been an interesting (if not a crossroads) year for Infor. Namely, after a number of new high-profile hires at the beginning of the year, which signalled Infor’s intention to be taken seriously, the vendor then entered an eerily quieter period of several months. Except for the ongoing vocal marketing campaign entitled “Down with Big ERP” with witty

sql if statements  Services (BIS) , since  SQL Server Reporting Services (SSRS)  will be the standard for reporting and  SQL Server Analysis Services (SSAS)  for underlying  online analytic processing (OLAP) cubes , whereas Infor PM and its know-how analytic frameworks will remain intact (coming from former Comshare , Extensity , SunSystems , etc.).? As for  Microsoft SQL Server  and  Windows Server  being the preferred respective database and operating system (OS) platforms, that is for go-to-market efforts, Read More

User Recommendations for the Food and Beverage Industry


Software systems must be able to handle your business basics. A focus on the details is essential. Look meticulously for the fatal flaws. If you don't select a system that meets your detailed needs, it can be fatal.

sql if statements  Recommendations for the Food and Beverage Industry User Recommendations How can you get help as a prospective enterprise applications user? Well, other companies in your category which have been through an application software implementation have scars that can be valuable. Consultants that have real experience in your specific category should know the issues. Ask the vendors, What makes your product good in our category? Ask enough vendors, and you should gain valuable insight into what the vendor c Read More

If There's One Thing CRM Tells Us: Don't Do PLM the Same Way


Product lifecycle management (PLM) doesn't work, but it should. Industry's general approach and attitude to PLM mimics the early days of customer relationship management (CRM) adoption, and lessons from that experience should help when tackling the "ifs" and "hows" of PLM investment.

sql if statements  There's One Thing CRM Tells Us: Don't Do PLM the Same Way Introduction: What Has CRM Got to Do with PLM? Product lifecycle management (PLM) doesn't work, but it should. Fundamentally, the idea that we can design better products and bring them to market more quickly by leveraging knowledge and experience from our own value chain and our customers and suppliers is a sound one. It's just that buying PLM doesn't always make that happen. In my view, industry's general approach and attitude to PLM very much Read More

How to Protect Your SQL Server Database


SQL Server deployments can be large and complex. However, Auto-Snapshot Manager simplifies data management tasks and offers a comprehensive approach to SQL Server protection by providing both local and remote database protection, allowing for quick data recovery in case of data loss or site failure. Find out more about how Auto-Snapshot Manager can provide you with the safety net you need for effective disaster recovery.

sql if statements  How to Protect your SQL Server Database If you receive errors when attempting to view this white paper, please install the latest version of Adobe Reader.   &#8220The Dell™ EqualLogic™ PS Series arrays offer the availability features necessary to integrate into a holistic plan that is designed to protect SQL Server data Source : Equallogic Resources Related to Sql Server Advanced Protection And Fast Recovery : Relational Database Management System (RDBMS) (Wikipedia) Structured Query Language(SQL Read More

Your Next IT Software Selection: Risk, Bottomless Money Pit or Opportunity


Every corporation needs to make decisions about the selection and implementation if new IT solutions on a regular basis. However, an industrial manufacturer or retailer cannot see this as being one of their core competencies. In most cases such a selection process is seen as a necessary evil rather than a challenge that uncovers new potentials within the company. Only the ones that are able to fully understand and control this process in conjunction with all internally and externally involved parties will be more successful then others. The implementation of new IT solutions can be a chance to increase efficiency, but only if the right goals are defined, the right solutions and partners selected, and results are being monitored on a continual basis. This white paper was designed to deliver you many hints on what to consider and help you reach your goals in your IT selection process faster.

sql if statements  Next IT Software Selection: Risk, Bottomless Money Pit or Opportunity Every corporation needs to make decisions about the selection and implementation if new IT solutions on a regular basis. However, an industrial manufacturer or retailer cannot see this as being one of their core competencies. In most cases such a selection process is seen as a necessary evil rather than a challenge that uncovers new potentials within the company. Only the ones that are able to fully understand and control this Read More

The Top Five Challenges with SQL Server Reporting and BI


Users of SQL Server value its power, speed, and affordability. But research shows that these users often face significant challenges in producing the business intelligence (BI)—reports, analysis, and dashboards—that they need to gain insight into their businesses. Learn how to evaluate three BI alternatives for Microsoft SQL users, and discover a new reporting and BI paradigm for SQL Server.

sql if statements  in different servers including SQL Server 2005/2008, SharePoint Server, and PerformancePoint Services. Also, Microsoft does not offer a data and report-checking integrity tool. Instead, Microsoft BI customers must expend a tremendous amount of IT effort manually testing the application. Finally, Microsoft's out-of-the-box monitoring capabilities are extremely limited and the monitoring reports remain relatively static and inflexible, which are of little use to the administrator. Because of these factors, Read More

Surado CRM High Availability


This document provides system administrators and technical professionals an overview of how Surado SCM SQL Enterprise CRM Solution can be used in a High Availability Environment. This document assumes that you are planning on installing the Surado SCM SQL System on Windows NT 4.0 or Windows 2000 Advanced Server and will be using Microsoft's SQL Server as the primary database.

sql if statements  of how Surado SCM SQL Enterprise CRM Solution can be used in a High Availability Environment. This document assumes that you are planning on installing the Surado SCM SQL System on Windows NT 4.0 or Windows 2000 Advanced Server and will be using Microsoft's SQL Server as the primary database. Read More

8 Rules for Investing in a New Accounting System


Find out if your current system is a drag on your company in Eight Rules for Investing in a New Accounting System.

sql if statements  Rules for Investing in a New Accounting System Are you sure your financial and accounting system is helping your company grow? It might actually be holding it back. Find out if your current system is a drag on your company in Eight Rules for Investing in a New Accounting System . You'll learn about the warning signs of a financial and accounting system that is dangerously outdated or lacking in critical functionality—and what you can do about it. You'll also discover the eight rules for choosing a Read More

What Does Vendor Consolidation Mean To The End User?


End-user companies should track the financial health of their vendors to see if the vendor will be a collector or one of the collected. If the end-user company has a focused vendor, think of that vendor's health and help them become even better in your type of business. If your vendor is acquired, meet the new owners. The new owners motivation in buying your product and vendor was the install base and that's you. Showing interest is your part in keeping the relationship the way you want it.

sql if statements  Does Vendor Consolidation Mean To The End User? Observation We continue to see evidence that the business application software space is consolidating, a process which has long started in the mid-market space (see The Mid-Market Is Consolidating, Lo And Behold ). Very recently, Invensys has put Baan up for sale. SSA GT also recently purchased interBiz and Infinium (see CA Unloads interBiz Collection Into SSA GT's Sanctuary and Is SSA GT Betting Infini(um)tely On Acquisitions?, and Is SSA GT Betting Read More