Convert Rows into Columns in SQL

I recently came across the following useful SQL query, Maybe you’ll find it useful. In Sql, Pivoting can convert rows to columns. We will see these features in details in this post. For example, we are considering a table named tblRowColumn to Here is SQL Query: First, Create table called tblRowColumn CREATE TABLE [dbo].[tblRowColumn]( [custID] [int] NULL, [Question] [varchar](50) NULL, [answer] [varchar](20) NULL ) ON [PRIMARY] Then, insert some values.. INSERT INTO tblRowColumn values(1000, 'AAA', '1') INSERT INTO tblRowColumn values(1000, 'BBB B', '2') INSERT INTO tblRowColumn values(1000, 'CCC', '3') INSERT INTO tblRowColumn values(1001, 'AAA', '2') INSERT INTO tblRowColumn values(1001, 'BBB B', '3') INSERT INTO tblRowColumn values(1001, 'CCC', '3') INSERT INTO tblRowColumn values(1000, 'DDD', '6') here is pivot query to convert rows to columns.. Declare @A VARCHAR(1000) Declare @B VARCHAR(1000) set @A='SELECT

How to add master page file for all the pages in a project

In web.config just add the master page file in the page tag.  <

Validate Multiple Emails with semicolon separated in .Net

  function validateEmail(field) {          

LINQ to Entities does not recognize the method 'get_Item(Int32)' method, and this method cannot be translated into a store expression.

LINQ to Entities does not recognize the method 'get_Item(Int32)' method, and

Keep ur coding aside.. Relax for some time..