- 71. Practical SQL: Don't Be Afraid of Recursio
- (SQL)
- ... final select, add the clause "where CMCORP = 0" and you'll get only the highest-level parent. Switch the inner join to "Corporate.ID = CMCORP" and now instead of parents, you'll get children. And this ...
- Created on 21 October 2009
- 72. Anchor Intelligence Reports Uncovering Huge Click-Fraud Ring
- (New Products, Agreements and Trends)
- ... “Every buyer or seller of online advertising that uses the Anchor ClearMark system becomes an instant winner in the battle against bad actors," he said. "Rather than fighting the arms race against the fraudsters ...
- Created on 12 October 2009
- 73. News Potpourri for the Week
- (Channel News)
- ... Other award winners of the IEEE 2009 Honors Ceremony include: Tingye Li, former division manager of AT&T Labs-IEEE Edison Medal Craig R. Barret, former chairman of Intel Corp.-IEEE Founders Medal Peter ...
- Created on 26 June 2009
- 74. Rev Up "i" Reporting with SQL Server 2008 Reporting Service
- (Microsoft)
- ... SUM(sd.OrderQty) AS Qty, SUM(COALESCE((UnitPrice*((1.0)-UnitPriceDiscount)) * OrderQty, 0.0)) AS LineTotal FROM SalesPerson sp INNER JOIN SalesOrderHeader ...
- Created on 27 May 2009
- 75. Modest Attendance at COMMON Belies Underlying Energy
- (Analysis of News Events)
- ... Bedenbender of Dot Foods (center) was the lucky winner of a camcorder at the ARCAD Software booth. Pictured with Corey are Joelle Cilley, ARCAD senior sales executive, and Philippe Magne, ARCAD CEO. ...
- Created on 02 May 2009
- 76. Practical SQL: Embedding SQL in Free-Format RPG
- (SQL)
- ... JOIN rather than an OUTER JOIN. Because of that, I don't have to worry about NULL values, but I will lose any customer records that don't have matches. Such is the tradeoff between INNER and OUTER ...
- Created on 24 February 2009
- 77. North Americans Enter IDUG's Global Search for XML Superstar
- (Database)
- ... prizes along with broad personal and community recognition are coming to XML superstar contest winners in the U.S., Canada and globally after the competition closes," says Julian Stuhler, president ...
- Created on 05 January 2009