Top IO
Top IO Report
Using your own RDL as a SSRS Template
This is very useful if you are creating many reports based on a single template. To start with when you use the “Add new Item” functionality into a report project, this is all you get. Report Wizard, Report, and Data Source. Then searching Online Templates is not very useful. So how do I add my own SSRS rdl templates. …
CTE Hierarchy compared to the alternative
After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people. Based on that feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some additional content. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path …
A Great Day at SQL Saturday 108 in Redmond.
WOW, what a great day at SQL Saturday 108 in Redmond. I started out with a keynote presentation from Buck Woody. Then I delivered my presentation on Common Table Expressions. Which I think went well. There were some great questions and I look forward to refining my presentation to include some of the questions that I was asked at the …
KeePass – for security and time savings
After a recent tour at a couple companies who are using the LEAN process, I have decided to take on LEAN in my everyday work. This is the first in what I think will be many videos on the Lean Office topic. Click the link below to watch the video. Lean2SecondKeePass [FMP width=”640″ height=”360″]http://stevestedman.com/wp-content/uploads/2012/02/Lean2SecondKeePass.mp4[/FMP] For more info on KeePass …
KeePass – to improve your process
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Do you write your passwords down? ( YES / NO ) Do you ever re-use a password on multiple systems or websites? ( YES / NO ) Are your passwords shorter than 8 characters? ( YES / …
Calculating Factorials with a Recursive CTE
What is a Factorial: The product of an integer and all the integers below it; e.g., factorial four (4!) is equal to 24. The factorial of a positive integer n, written n!, is the product of all the positive integers from 1 up to and including n Example: 1! = 1 2! = 1 * 2 = 2 3! = 1 * …
CTE – With An Insert Statement
Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for SQL Saturday, the question came up of can you use an INSERT or UPDATE statement with a CTE. Referring to the documentation I confirmed that using an insert or update inside of the CTE is …
Fibonacci Sequence
As part of my CTE research for my SQL Saturday presentation in Redmond in 2 weeks I decided to take on some classic computer science algorithms with CTE’s. Here is what I cam up with. Any math geek can tell you what the Fibonacci Sequence is, but do you know how to calculate it with a query? First, what is …
Generating a Tree Path with a CTE
The following example shows how to create a Tree Path with a Common Table Expression (CTE). First off what is a tree path? For this example I will be referring to the product categories at a camping and fitness store, where you have a top level with 4 categories, and some of the categories have subcategories: Camping Tents 1 Person …