It is common developer requirement to get missing records from series. For that they generate temporary table and insert complete list of numbers and then find missing numbers using LEFT JOIN. In SQL Server 2005 and 2008, new keyword “WITH” introduced that works with SELECT, INSERT and UPDATE statement that use to create temporary resultset [...]

Posted in Microsoft, Programming No Comments »

There is no function in ASP to count number of words in sentence or long string. Bellow is very simple function that count number of words and return that count.

< %
Function CountWords (StrValue)
Dim iWords, mLengthWithSpaces, mLengthWithoutSpaces

‘ following line calculate the actual length of string
mLengthWithSpaces = Len(StrValue)

‘ following [...]

Posted in Programming, Visual Basic No Comments »

Trim is a useful String function available in languages like Visual Basic, Java & PHP which removes all leading and traling whitespaces from a String. Unfortunately Javascript does not provide Trim functionality to the String object. But there is solution using Regular Expression. Use following code in top of your Javascript file. Following code will [...]

Posted in Programming No Comments »

One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format.  Here’s a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.  Following the standard date formats are some extended date formats [...]

Posted in Programming 1 Comment »