My enthusiasm for Biml must be catching because I’ve been asked to give two presentations next week.
I’ll be giving a brand new presentation on Tuesday, November 12th, at 4:30pm for the MSBIC group at the Microsoft Building in Irving, TX. This presentation is targeted towards Business Analysts, management, and other members of the data warehouse [...]
A “Hello World” program is an ages old traditional way to teach the basics of syntax for a programming language to a beginner. Since so many of us are just starting to use Biml Script, I thought it would be fun to start out with it. Also, I’ve made the entire solution available for download.
All of the queries we’ve looked at so far will return all of the records in a table. This isn’t very efficient. The Where clause filters records out of your result set that you do not want.
For example, suppose we’re only interested in Sales Order Master records for “Acme Rockets Inc.” The following select [...]
I mentioned in my last article that I would be posting a video showing you the basics of working with Toad for SQL Server.
What do you think of my first effort?