Visit a content portal to find information, resources, and help over a wide range of topics, projects, and issues.
By Naomi N July 2, 2013
The problem of transposing rows into columns is one of the most common problems discussed in Transact-SQL forum. Many times the problem of creating a dynamic pivot comes into the light. One thing that many people who ask this question forget is that such transposing is much easier to perform on the client side than on the server where we need to resort to dynamic query. However, if we want to make such pivot dynamically...
By isenthil June 29, 2013
The Windows Phone 8 supports 3 different screen resolutions like WVGA,WXGA,720P. If you are a developer and want to retreive the screen resolution dynamically , you can use the ScaleFactor property defined in App.Current.Host.Content.ScaleFactor. Eg: string data = App.Current.Host.Content.ScaleFactor.ToString(); This will retreive the one of the 3 values 100 , 160 , 150 which refers to the screen resolutions...
By Naomi N June 27, 2013
Recently I helped to solve a relatively simple problem. I'll quote my solution and then I'll explain the main problem people often encounter with PIVOT solutions. The pivot solution by itself is not complex, it's a simple static PIVOT. But the thread originator was having a problem arriving to it. The main problem is to understand, that all columns which are not mentioned in the PIVOT aggregate function in the PIVOT clause will be aggregated, so if there...
By Sachin S June 24, 2013
This article provides spell checking functionality for Windows Store Apps, which is missing out-of-box for C#-VB/XAML, HTML/JavaScript apps. This was implemented in response to MSDN forum questions where developers are often looking for spell check solutions in C# or JavaScript apps. Writing a wrapper over the spell checker factory is easy. However, it could be a little tricky for C# developers...
More featured articles