Thanks for reply.

Please use the following script for sample data...

CREATE TABLE [dbo].[test](
[QesID] [varchar](50) primary key,
[ChpID] [varchar](50) NULL,
[QesComplexity] [varchar](50) NULL,
[QesType] [varchar](50) NULL,
[QesQuestion] [varchar](1000) NULL,
[Marks] [int] NULL)

INSERT [dbo].[test]...