Hi,

Here is your answered query,

please take a look.

CREATE TABLE #temp

(

[Column A] VARCHAR(10),

[Column B] VARCHAR(10)

)

INSERT INTO #temp VALUES ('abnc','123')

INSERT INTO #temp VALUES ('abnc','324')

INSERT INTO #temp VALUES ('abnc','800')

INSERT INTO #temp VALUES...