declare @t table ( orderId int, code_dest char(1) ) decl...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

declare @t table
(
  orderId int,
  code_dest char(1)
)

declare @t2 table
(
  ID_VOIT int,
  orderId int,
  code_dest char(1)
)

insert into @t values (1, 'a')
insert into @t values (2, 'b')
insert into @t values (3, 'c')
insert into @t values (4, 'a')
insert into @t values (5, 'a')
insert into @t values (6, 'b')
insert into @t values (7, 'g')

declare @i int
set @i = 1

insert into @t2
select 1, orderId, code_dest from @t order by code_dest, orderId

select * from @t2

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results