tag:blogger.com,1999:blog-3689647052791307812.post5308440120132424888..comments2024-01-27T22:41:04.808+11:00Comments on Richard Lees on BI: Learn SQL - SELECT Product(column)Richard Leeshttp://www.blogger.com/profile/05671716466559973540noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3689647052791307812.post-41997123980589666992012-01-04T17:24:17.428+11:002012-01-04T17:24:17.428+11:00Thanks a bunch for the tip :)Thanks a bunch for the tip :)akhila athreshhttps://www.blogger.com/profile/06955494462181873077noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-85459360134902804582009-11-17T21:56:22.590+11:002009-11-17T21:56:22.590+11:00finding the product using sum,exp and log really w...finding the product using sum,exp and log really works... thanks for the tip..Amit Bulbulehttps://www.blogger.com/profile/01078288385941287062noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-71435371946079454302009-06-19T16:19:03.283+10:002009-06-19T16:19:03.283+10:00While I generally agree with you, I'm curious ...While I generally agree with you, I'm curious as to how then you would approach populating a nested set table?Kristen Hodgeshttps://www.blogger.com/profile/02708872213558099042noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-66816486255731101162009-06-19T06:08:30.628+10:002009-06-19T06:08:30.628+10:00Excellent! A while back my typical day used to la...Excellent! A while back my typical day used to largely consist of re-writing large batches or cursor based batches in more efficient set based operations. I found this old link to a <a href="http://www.sqlmag.com/Article/ArticleID/23162/sql_server_23162.html" rel="nofollow">SQL Server Magazine competition</a> for writing a cross tab in a single query.Tony Bainhttps://www.blogger.com/profile/09787797480155618139noreply@blogger.com