|
|
News and Information for the Data Integration community
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Top 5 SQL Server 2005 Analytic Functions
SQL Server 2005 added many new analytical functions. Here is a gist of
most important ones. Enjoy! - Pradeep.
Row_Number :
Assigns a sequential identifier to each record of the result set, as in the following
example:
|
|
|
|
|
New version available!
xFusion 3.0 offers many new features to better handle your many migration and integration
projects. Current customers can request download instructions and license keys from
sales@softlabsco.com
New Partners.
We are happy to announce the addition of GT
Solutions , Niefert Certified Solutions
to our growing list of partners. xFusion will benefit them internally with customer
migrations, as well as their customers through ongoing integration of company-wide
information.
Need SOA capable business applications?
xFusion WebDB Server now enables remote business applications to exchange data in
Service Oriented Architecture (SOA) environment. The power of xFusion WebDB Server
and web services combine to make more data available across the enterprise. Learn
more at www.examinfusion.com
Microsoft Reporting Services working together with xFusion.
Need to create reports from multiple data sources, including those from outside
offices? xFusion makes it easier to collect and report on important information
on a scheduled or adhoc basis. Learn more at www.softlabsco.com
New xFusion "Insight" Add-On for Oracle and SQLServer
Software Labs has just released a value-added and resourceful server monitoring
tool for Oracle, SQL Server and SAP Business One environments named xFusion SQLServer
Insight v2007.1, xFusion Oracle Insight v2007.1 and xFusion SBO Insight v2007.1
respectively.
|
|
|
|
|
|
|
New version available!
xFusion 3.0 offers many new features to better handle your many migration and integration
projects. Current customers can request download instructions and license keys from
sales@softlabsco.com
New Partners.
We are happy to announce the addition of GT
Solutions , Niefert Certified Solutions
to our growing list of partners. xFusion will benefit them internally with customer
migrations, as well as their customers through ongoing integration of company-wide
information.
Need SOA capable business applications?
xFusion WebDB Server now enables remote business applications to exchange data in
Service Oriented Architecture (SOA) environment. The power of xFusion WebDB Server
and web services combine to make more data available across the enterprise. Learn
more at www.examinfusion.com
Microsoft Reporting Services working together with xFusion.
Need to create reports from multiple data sources, including those from outside
offices? xFusion makes it easier to collect and report on important information
on a scheduled or adhoc basis. Learn more at www.softlabsco.com
New xFusion "Insight" Add-On for Oracle and SQLServer
Software Labs has just released a value-added and resourceful server monitoring
tool for Oracle, SQL Server and SAP Business One environments named xFusion SQLServer
Insight v2007.1, xFusion Oracle Insight v2007.1 and xFusion SBO Insight v2007.1
respectively.
|
|
|
|
|
|
|
|
Did you know that we used xFusion to send this newsletter?
xFusion Studio 3.0 has a bulk email feature to help you send emails to
your contacts.
Read
more...
|
|
|
|
|
|
Hi Support:
In a grouping query, is there a way to concatenate string data?
|
IBM
|
George
|
|
IBM
|
Sam
|
|
IBM
|
Alice
|
|
Dell
|
Steve
|
|
Dell
|
Bob
|
I want to convert the table above to the following
|
IBM
|
George, Sam, Alice
|
|
Dell
|
Steve, Bob
|
How do I accomplish this?
Thanks,
Support:
Hi, the following query will solve the problem:
groupBy ([[FmtDetailsSortFilter]],
array ("[FmtDetailsSortFilter.Company]",
"DelimitedText([FmtDetailsSortFilter.test],';', true) as Txt"),
array ("[FmtDetailsSortFilter.Company]"))
|
Thanks.
|
|
|
|
