Tag: sql server


Expanding Hierarchies

Microsoft has expanded the information about expanding hierarchies in SQL Server Books Online (BOL) since SQL Server 6.x. But the BOL solution merely displays the output; you can’t join the results with other views, tables, or results. My T-SQL coding solution fills this gap. Also, the solution I pr


Delivering Data To Mobile Users

Another solution we have found is to use the offerings from Microsoft's SQL Server 7. SQL 7 has a few key pieces of functionality that lend themselves to the sometimes disconnected user. The first key piece is the MSDE (Microsoft Data Engine), which is actually the guts of SQL 7 without the fron