Kbdavis07 Blog: November 2011

Wednesday, November 30, 2011

Finding and Deleting the Duplicate Rows Using SQL Partition By http://ping.fm/jVx4p

ISALPHA and ISINT in SQL Server http://ping.fm/Q35LA

Saturday, November 26, 2011

How to Add a Custom Field to a Post in BlogEngine.Net http://ping.fm/YOnK9

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/7WaSW

HTML DIV tag inside HTML P (paragraph) Tag does not work Correctly http://ping.fm/YqYM3(paragraph)-tag-does-not-work-correctly-.aspx#.TtDxlUnndsg.pingfm

Friday, November 25, 2011

New BlogEngine Theme KoolLuks Is For Sale Now Just $99.00!
http://ping.fm/Jhf7d$.aspx

How to Loop through all files in a folder using VBA http://ping.fm/xgDyt

Create Folder if the Folder does not Exist in VBA http://ping.fm/nWJd8

Checking a Date whether it is weekend or monthend in VBA http://ping.fm/LoCC2

Finding Last n members of a Particular month of a particular Year from a Time Dimension using MDX http://ping.fm/ta0Au

Finding Invisible Characters in TSQL String and Remove Invisible Characters with Space http://ping.fm/9nyR2

Thursday, November 24, 2011

Introducing the Design Tab of Pivot Table Tools in Excel 2007 http://ping.fm/rhrxW

SQL Server Table Design: Saving changes is not permitted http://ping.fm/hNFMN

Finding All the Unicode Character Values Used in a String using TSQL http://ping.fm/b3tJx

SQL Server Array: Implementing TSQL Array Using XML and XQuery http://ping.fm/AkHeC

Removing Leading and Trailing White Space Characters in TSQL http://ping.fm/ngM6W

Wednesday, November 23, 2011

Look at the live version of the ImpreZZ theme
http://ping.fm/n1n7E blogengine

Only 4 hours left to Vote! Please Vote for the ImpreZZ Theme blogengine
http://ping.fm/ju6h0

Vote for the ImpreZZ Theme
http://ping.fm/aJ5RV blogEngine

Today Is the Last Day to vote for the ImpreZZ Theme so Please vote currently its in 10th place.
http://ping.fm/JVpHD

URL Parsing Using JavaScript: Get Domain Name, Port Number and Virtual Directory Path http://ping.fm/KHgOU

Tuesday, November 22, 2011

Where to get VseWss 1.3 Service http://ping.fm/1OdOd

Inserting Rows into SQLServer from CSV file http://ping.fm/mHIN8

Period Dimension (Time Dimension) Creation with Year, Month, Day Hierarchy http://ping.fm/DNz6G

Date formatting in SQL Server http://ping.fm/mXnek

MDX query for Subtree Members and Leaf Members http://ping.fm/E8c1s

Finding Last n members of a Particular month of a particular Year from a Time Dimension using MDX http://ping.fm/jtLGR

Integer sequence generator, Date sequence generator http://ping.fm/nBFaP

Comma Separated List (CSV) of rows of a column using FOR XML PATH http://ping.fm/26ljL

Creating Connection to an Analysis Service Database or Cube from Excel 2007 http://ping.fm/ydkdg

Hierarchical Ordering of Members of a Hierarchy http://ping.fm/fSEfp

Nested case when statement http://ping.fm/g4LXR

Getting XML node names and values in tabular format http://ping.fm/tgnan

XML Data into a Relational Table Using OPENXML http://ping.fm/GhDmV

Use of SQL Case Statement in SQL Update Statement http://ping.fm/S5UFd

EXECUTE sp_executesql http://ping.fm/Uh6Bi

Comma Separated string of all the rows of a column http://ping.fm/jpM8y

SQL Server Pivot: Converting Rows to Columns with Dynamic Query http://ping.fm/v6zmy

SQL Partition By clause http://ping.fm/oM5yi

Monday, November 21, 2011

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/kCvbQ

Sunday, November 20, 2011

Enter a Newline in a Value of a Cell in Excel http://ping.fm/bqHlt

Logical Primary Key cannot be changed in DSV in SSAS 2008 http://ping.fm/8SWcw

Saturday, November 19, 2011

Creating Local Cube or Offline Cube from SSAS 2008 http://ping.fm/RYjS7

JSON to Object Conversion in C# http://ping.fm/cKIg1

JavaScript Add Array to Array http://ping.fm/NK9RA

Creating Role in SQL Server Database using C# http://ping.fm/pE5ER

Data Generation Plan to Generate Dummy Test Data for SQL Server Tables http://ping.fm/3FWUs

Friday, November 18, 2011

How to Cast JQuery Object to JavaScript Object and JavaScript Object to JQuery Object http://ping.fm/VUKXS

Regular Expression in Visual Studio Data Generation Plan http://ping.fm/sRWlg

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/TJBHx

SQL Server Xquery FLWOR Examples http://ping.fm/77GNe

Creating Local Cube or Offline Cube from SSAS 2008 http://ping.fm/LUMmU

Thursday, November 17, 2011

I am getting a VSeWSS Service Error http://ping.fm/Fqn4c

How to do DYNAMIC Market Share Calculation http://ping.fm/yl51Q

Using SQL case statement in order by clause http://ping.fm/KZXCA

Hierarchical sorting of a parent child relationship table data http://ping.fm/yDrT6

TSQL Delete Statement http://ping.fm/uWeHU

Wednesday, November 16, 2011

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/iUGpt

Tuesday, November 15, 2011

Vote for the ImpreZZ Theme voting is till 23 Nov!
http://ping.fm/hGa0r blogengine

Don't forget to Vote for the ImpreZZ theme Voting is from 16 Nov - 23 Nov
http://ping.fm/tafy0
#blogengine

Monday, November 14, 2011

How to do DYNAMIC Market Share Calculation http://ping.fm/164PY

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/ZIGuM

Regular Expression in Visual Studio Data Generation Plan http://ping.fm/Gp6w2

How to Cast JQuery Object to JavaScript Object and JavaScript Object to JQuery Object http://ping.fm/WCKrz

Using SQL case statement in order by clause http://ping.fm/2Dkpn

Hierarchical sorting of a parent child relationship table data http://ping.fm/jBhMS

Saturday, November 12, 2011

Get the Newest BlogEngine.Net Theme: [ImpreZZ]
http://ping.fm/jRM0g

ImpreZZ Theme For BlogEngine.Net
http://ping.fm/eILvX

Wednesday, November 9, 2011

How to Cast JQuery Object to JavaScript Object and JavaScript Object to JQuery Object http://ping.fm/jiPmP

Regular Expression in Visual Studio Data Generation Plan http://ping.fm/3YJaA

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/ULpZ5

Regular Expression in Visual Studio Data Generation Plan http://ping.fm/dC8St

Casting JQuery Object to JavaScript Object and JavaScript Object to JQuery Object http://ping.fm/pJsf2

How to Cast JQuery Object to JavaScript Object and JavaScript Object to JQuery Object http://ping.fm/xvMG4

Tuesday, November 8, 2011

How to use Windows Live Writer with BlogEngine.Net 2.5

How to use Windows Live Writer with BlogEngine.Net 2.5: How to set up and use Windows Live Writer to post to BlogEngine.Net 2.5

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/fGBqN

How to use Windows Live Writer with BlogEngine.Net 2.5 http://ping.fm/h5elH

Monday, November 7, 2011

SQL Server Xquery FLWOR Examples http://ping.fm/ktUnv

Creating Local Cube or Offline Cube from SSAS 2008 http://ping.fm/V0BrC

Casting JQuery Object to JavaScript Object and JavaScript Object to JQuery Object http://ping.fm/yYPmS

Removing Leading and Trailing White Space Characters in TSQL http://ping.fm/DMHae

Sunday, November 6, 2011

ListView, ListViewItem and ListViewSubItem in .Net Windows Form

ListView, ListViewItem and ListViewSubItem in .Net Windows Form:

How to populate items in a ListView

NullReferenceException: On SelectionChangeCommitted and SelectedIndexChanged

NullReferenceException: On SelectionChangeCommitted and SelectedIndexChanged:
While working with ComboBox in .Net windows form, I got an error

System.NullReferenceException:

Object reference not set to an instance of an object. at SP_Script_Generator.Form1.procedureType_SelectedIndexChanged(Object sender, EventArgs e)

Enter a Newline in a Value of a Cell in Excel

How to setup the server where the cube will be deployed

Get Detail Error Message for "An unexpected error has occurred”

VBA Power Function http://ping.fm/0Kxit

VBA For Loop/For Each Loop: Different Way of using VBA For Loop

VBA For Loop/For Each Loop: Different Way of using VBA For Loop: Different Ways of using VBA For Loop

Finding Last n members of a Particular month of a particular Year from a Time Dimension using MDX http://ping.fm/DtaPv

Getting XML node names and values in tabular format http://ping.fm/FGGMh

XML Data into a Relational Table Using OPENXML http://ping.fm/GByQF

Use of SQL Case Statement in SQL Update Statement http://ping.fm/5YsYS

SQL Server Xquery FLWOR Examples http://ping.fm/g2YxD

Using sql case statement in order by clause http://ping.fm/t1MXF

EXECUTE sp_executesql http://ping.fm/8G69d

Comma Separated string of all the rows of a column http://ping.fm/XJdyz

XML Data into a Relational Table Using OPENXML http://ping.fm/dK7Mx

Dynamically Accessing JavaScript Object Property and Object Member Method Using Variable http://ping.fm/3J5te

Dynamically Accessing JavaScript Object Property and Object Member Method Using Variable http://ping.fm/S8Pxa

Changing Default MDX Query Generated by SSRS Query Designer to Avoid set with more than 4,294,967,296 tuples error http://ping.fm/H6r0C

MDX query for Subtree Members and Leaf Members http://ping.fm/rWlDb

MDX query for Subtree Members and Leaf Members http://ping.fm/8Em4O

Regular Expression in Excel Find and Replace Window http://ping.fm/YePPK

Integer sequence generator, Date sequence generator http://ping.fm/2WPWE

Implement JavaScript HashTable http://ping.fm/4sE42

JQuery Accordion Item Height Adjust Based on Content http://ping.fm/g82Hu

JavaScript Add Array to Array http://ping.fm/judtt

Comma Separated List (CSV) of rows of a column using FOR XML PATH http://ping.fm/Bs9FY

JavaScript Add Array to Array http://ping.fm/DhIYl

JSON to Object Conversion in C# http://ping.fm/gRUe0

JavaScript Add Array to Array http://ping.fm/SzvpD

JavaScript Add Array to Array http://ping.fm/x1unr

Saturday, November 5, 2011

JavaScript Add Array to Array http://ping.fm/HDCRM

Changing Default MDX Query Generated by SSRS Query Designer to Avoid set with more than 4,294,967,296 tuples error http://ping.fm/zK19k

Iframe src error: Content was blocked because it was not signed by a valid security certificate http://ping.fm/LtZPm

XQuery Concat Function http://ping.fm/7TTEO

How to setup the server where the cube will be deployed http://ping.fm/z207z

Finding All the Unicode Character Values Used in a String using TSQL http://ping.fm/j78n8

JavaScript Add Array to Array http://ping.fm/ZWjoM

JavaScript Add Array to Array http://ping.fm/VHCdS

MDX query for Subtree Members and Leaf Members http://ping.fm/HbpdB

Iframe src error: Content was blocked because it was not signed by a valid security certificate http://ping.fm/g04Us

Create Folder if the Folder does not Exist in VBA http://ping.fm/VLwIS

ListView, ListViewItem and ListViewSubItem in .Net Windows Form http://ping.fm/7iwsT

SelectionChangeCommitted and SelectedIndexChanged events: System.NullReferenceException while closing Windows Form http://ping.fm/xE0AT

Delete Rows of a Table Matching Multiple Columns of Another Table http://ping.fm/cFk83

How to setup the server where the cube will be deployed http://ping.fm/yBkYh

Where to get VseWss 1.3 Service http://ping.fm/x3W3o

Get Detail Error Message for "An unexpected error has occurred” http://ping.fm/BY6Es

Enter a Newline in a Value of a Cell in Excel http://ping.fm/TMgwH

SelectionChangeCommitted and SelectedIndexChanged events: System.NullReferenceException while closing Windows Form http://ping.fm/PtbSK

ListView, ListViewItem and ListViewSubItem in .Net Windows Form http://ping.fm/Y7Y43

VBA For Loop/For Each Loop: Different Way of using VBA For Loop http://ping.fm/WSEA4

URL Parsing Using JavaScript: Get Domain Name, Port Number and Virtual Directory Path http://ping.fm/nLEmw

Delete Rows of a Table Matching Multiple Columns of Another Table http://ping.fm/72u6x

Javascript variable declaration with Var and without Var: Global variable Vs Local Variable http://ping.fm/P3QnW

HTML Div tag inside HTML P (paragraph) tag does not work correctly http://ping.fm/gjiAK(paragraph)-tag-does-not-work-correctly-.aspx#.TrW46gG0lwo.pingfm

HTML Div tag inside HTML P (paragraph) tag does not work correctly http://ping.fm/Fan5Z(paragraph)-tag-does-not-work-correctly-.aspx#.TrW4065y94g.pingfm

Implement JavaScript HashTable http://ping.fm/KfB3M

JavaScript Object Array Sorting: Using Custom Comparison Function http://ping.fm/z2My0

Period Dimension (Time Dimension) Creation with Year, Month, Day Hierarchy http://ping.fm/fHmbB

Retrieve SSAS Cube Data in Tabular Format from Stored Procedure using Linked Server http://ping.fm/RRRm0

Friday, November 4, 2011

Review my Programming Solutions Website
http://ping.fm/Hw5ru

Iframe src error: Content was blocked because it was not signed by a valid security certificate http://ping.fm/HoYi3

VBA For Loop/For Each Loop: Different Way of using VBA For Loop
http://ping.fm/lBxVB

Comma Separated List (CSV) of rows of a column using FOR XML PATH
http://ping.fm/JvdfA

URL Parsing Using JavaScript: Get Domain Name, Port Number and Virtual Directory Path
http://ping.fm/OhF9L