(SQL Server 2000)<BR><BR>I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.<BR><BR>I then have a correlated subquery that runs against the temp ...
I have a result set stored in #Results.<BR><BR>Now I need to add MORE records to that #Results table.<BR><BR>The first query selects all of our employees and stores it in #Results.<BR><BR>Now what I ...
The queries in this collection focus on analyzing donor and product order data for a non-profit organization. They highlight essential BI techniques, including trend analysis, segmentation, ranking, ...
The procedures can be deployed on the master database with the included rakefile (or just manually open them in SQL Server Management Studio and run them on master) Once they are deployed you can call ...