August 2008 - Posts

0
Comments

SQL Not In Revisited by StarPilot

I always seem to struggle with a NOT IN clause when there are more than one column to compare.  This, of course, comes up when I am trying to get records from one set that are NOT IN another set and the comparison has to be done across multiple columns...
Filed under:
0
Comments

SQL XML - TreeView by StarPilot

I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship.  There is a great explanation on SQL Server Central on *how* to do this .  I am mainly capturing the link and the SQL I just...
Filed under: ,
More Posts