 |
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 , and Elevation
Group 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 , and Elevation
Group 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. |
|
|
|
