Random notes on MDX filtering

Stored Procedure with sorting, paging, and filtering.

This post is designed to help you understand how to use the EXISTS keyword in your SQL query environment.

Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.

The new Merge statement in SQL Server 2008.

Background In my last post I showed how to split a string in TSQL. Problem with that splitting is it can split a string if resultant split count is <=2, i.e. it can split only string like &#8220;a,b&#8221; or &#8220;first,last&#8221; or &#8220;java,c&#8221;. But while doing the parsing of  string of

Background When you see the your database in Suspect mode that a code red situation. Its not something that you face everyday. It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file). This post will show how to recover from suspect mod

This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.

[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we&#8217;ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this &#8230; Continue reading &#8594;

Introduction to MonoTouch Library sqlite-net

Using a controller to manage dynamic control form events and creation.

List out reports from Reprting Server.

Creation of random and unique code

Merge in SQL Server 2008.

Create a calendar by inputting month

Difference between SQL Server Char and Varchar data type.

Passing a comma separated list of values to an SQL query is all very well, but you can't just use them in an "IN" clause. This helps.

This tip explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by SQL Server.

Paging DataGridView using LINQ in C#.