My friend Jacob Sebastian runs a very interesting T-SQL quiz this month and everyone is encouraged to take part in it and have a chance to win a prize. I participated in the very first SQL quiz a few months ago. I can say that I learn a lot when I was trying to answer hard questions and doing a research. This time I am participating as a Quiz Master. My question is now open for all answerers.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Thank you to everyone that participated in T-SQL Tuesday #016: Aggregate Functions. I’d consider this a smashing success with 42 posts submitted! I’d like to give a shout out to my LessThanDot.com posse for letting me host, and writing excellent posts. I’ve been on the site for four months now, and I’m loving it here. A special thank you goes to the 13 Microsoft MVPs for sharing your expertise with us, especially since many of you were at Summit and had a busy week.
It looks like Visual Studio 2010 Service Pack 1 is available on MSDN, the files have a timestamp of today. I have been running the beta for a couple of weeks at home, finally I can install this at work. If you don’t have a msdn subscription, then you can download Visual Studio 2010 Service Pack 1 here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=75568aa6-8107-475d-948a-ef22627e57a5&displaylang=en ![][1] [1]: /wp-content/uploads/blogs/DesktopDev/VS%20sp1.PNG “”
This month’s T-SQL Tuesday is being hosted by our very own, Jes Borland (Twitter | Blog). Not only is she hosting this month but she is making it possible for LessThanDot’s first T-SQL Tuesday event. The topic that is brought to us is to discuss with everyone how we solved business problems with aggregate functions. I thought this would be a good time to explain how you can write a pivot query in SQL 2000 using aggregate functions.
This month’s T-SQL Tuesday is hosted by Jes Borland and it is all about grouping and aggregate functions. With the introduction of window functions in T-SQL language in SQL 2005, getting top N values per group became a simple task of utilizing DENSE_RANK() or RANK() or ROW_NUMBER() function depending on the business requirements. However, there is still an important aggregate missing from the group. In particular, PERCENT() aggregate function. There is a Connect item in regards to the missing functions.
For my documentation project I need and want to take screenshots from just about anything in my application. The normal way to this would be to push Printscreen on the keyboard and then open paint click save, give it a name and then got to the next screen. From a programmers point of view I see that I can automate quite a few steps and that I need an assistant. Since it will take a while to hire an assistant I will have to automate as much as possible.
This month’s T-SQL Tuesday is hosted by Jes Borland and it is all about grouping and aggregate functions, here is my attempt. I wrote most of this post on my way to the MVP summit in Seattle. This post is all about the stock market, charting data for Intraday chart and for end of day charts. This post contains a lot of code and I apologize for that, I just want you to be able to run the code, in order to do that we have to setup all the tables and data.
This month’s T-SQL Tuesday is being hosted by our very own, Jes Borland (Twitter | Blog). Not only is she hosting this month but she is making it possible for LessThanDot’s first T-SQL Tuesday event. The topic that is brought to us is to discuss with everyone how we solved business problems with aggregate functions. I thought this would be a good time to delete some data so here is my post on the topic.
Something that you are used to doing on one platform is not always the best thing on another platform. Compacting databases might be good in Access, shrinking databases is not so good in SQL Server. Looping in SQL Server instead of using a SET based solution is another mistake that some procedural programmers make. A couple of minutes ago I saw this question on StackOverflow: SQL Server equivalent of MySQL Dump to produce insert statements for all data in a table
In an attempt to overcome my perfectionism I’ve decided to open source my long term side project Machete for the world to see. Machete is my own dialect of the ECMAScript 5 standard or as it is more commonly called JavaScript. Features Cleaner lambda expressions: var succinct = (x, y) x + y; var verbose = function (x, y) { return x + y; }; First class iteration support with the foreach loop and generators.