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.
<
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