This script uses an old mathematical way of doing hierarchical queries. The most common way of showing hierarchical data in SQL Server is by creating a stored procedure that calls itself. This is not a recent problem, in fact this programming technique has been around since the first programming languages. By using stacks, you can […]
2007-05-02 (first published: 2004-02-17)
557 reads
Get the Last date of the month for the given month and year
2004-09-30 (first published: 2004-02-16)
92 reads
This will return the weekno of the given date
2004-10-01 (first published: 2004-02-16)
129 reads
This is an entry level look at how temp tables work in SQL along with some tips about how to use them effectively.
2007-10-02 (first published: 2004-02-11)
81,613 reads