(Rudy Limeback) There is a table called User (userID PK, userName, supUserID FK). SupUserID refers to userID and contains the userID value of the user’s superior. The highest user has no user superior to itself (NULL instead of a value) and can have under itself one or more users or no users at all.
Other News
Random Sampling in T-SQL
(Brian Connolly) Whether you’ve got a gargantuan data warehouse, a huge transaction database, or a smaller workgroup database or data mart, it’s not uncommon to want to “sample” your data. Although selecting a random sample of rows isn’t a natural SQL operation, over the years, SQL Server profession
Databases Get a Grip on XML
(Sean McCown) Being able to merge, query, and transform transmitted data with relational data is becoming as essential to businesses as data warehouses themselves. The good news is that the four leading relational databases, namely Oracle Database, IBM DB2, Sybase ASE (Adaptive Server Enterpri
Analyzing Data with Crosstabs
The following information describes crosstabs and how to create them using DB2 and Lotus Approach.
XML paging using XML + XSL + CSS
(Matthew Hazlett) Hello again, I decided to take a break from graphics and do some XML. I created an XML Pager, what it does is read an XML file and apply an XSL translation and send params to it to create a paged document. Important, you need to have ASP.NET 1.1 running on your server! ASP.NET 1
XML Matters: GUIs and XML configuration data
(David Mertz) Over time, XML has permeated many niches. One area where XML is used increasingly is in the configuration of graphical user interfaces, especially in elements that are persistent but should not be fixed at compile-time. In this installment, David looks at the use of XML in Mac OS X
Create 3D representations with XSLT and SVG
(Nicholas Chase) In part 4 of this series on analyzing data with XSLT, the MindMap Research Team realized that the cognitive data they’re analyzing might be easier to understand if represented in the 3D space for which it is intended. The team decides to use XSLT to transform it into a 3D graph
Developing CLR-Based Stored Procedures
(William Vaughn) One of the most innovative features in the upcoming SQL Server 2005 release, formerly code-named Yukon, is Common Language Runtime (CLR)-based code execution. If you’re a developer or your job combines the duties of developer and DBA, you probably know about the CLR. But if you’
Give and Take: Integrating Information in the 21st Century
(Ken North) Never a simple undertaking, integration becomes even more challenging as performance demands increase, grids gain a foothold in enterprises, and regulations mandate tight privacy controls and document retention policies. IBM Distinguished Engineer Jim Kleewein explains why DB2 Informatio
Creating serial number columns
(Barrie Sosinsky) Auto-incrementing columns are important when you need serial numbers or key fields for joins. In DB2 for versions 7 and later you can add the IDENTITY clause to the CREATE TABLE statement to create such a column. (R)