SQL Query Solution

Question

I have one table with rows(1 to 5) and need a output like below Table: ║no ║Years ║ ╠══╬════║ ║ 1 ║ 2001 ║ ║ 2 ║ 2002 ║ ║ 3 ║ 2003 ║ ║ 4 ║ 2004 ║ Output : ║no ║Years║ ╠══╬════ ║ 1 ║ 2001 ║ ║ 2 ║ 2002 ║ ║ 3 ║ 2003 ║ ║ 4 ║ 2004 ║ ║ 4 ║ 2004 ║ ║ 3 ║ 2003 ║ ║ 2 ║ 2002 ║ ║ 1 ║ 2001 ║

Dharmesh Singh · Answer

Hi balaji palani I had inserted static value in temp table because I do not have physical table. You can do with physical table please consider following code CREATE TABLE # TEMP ([ NO ] INT [ YEAR ] INT ) INSERT INTO # TEMP SELECT T2.NOOFYEART2.[ YEAR ] AS DEM FROM NOOFYEAR T2 ORDER BY T2.NOOFYEAR ASC INSERT INTO # TEMP SELECT T2.NOOFYEART2.[ YEAR ] AS DEM FROM NOOFYEAR T2 ORDER BY T2.NOOFYEAR DESC SELECT T1.[ NO ]T1.[ YEAR ] FROM # TEMP AS T1 in this code NOOFYEAR is a physical table it work as you want CREATE TABLE #TEMP ([NO] INT [YEAR] INT) INSERT INTO #TEMP SELECT T2.NOOFYEART2.[YEAR] AS DEM FROM NOOFYEAR T2 ORDER BY T2.NOOFYEAR ASC INSERT INTO #TEMP SELECT T2.NOOFYEART2.[YEAR] AS DEM FROM NOOFYEAR T2 ORDER BY T2.NOOFYEAR DESC SELECT T1.[NO]T1.[YEAR] FROM #TEMP AS T1

Dharmesh Singh · Answer

--It'sHelpYou create table # temp ( no int [ Year ] int ) insert into # temp values (1 '2001' )(2 '2002' )(3 '2003' )(4 '2004' ) create table #temp1(id int identity(11)noOfDay int [ Year ] int ) create table #temp2(id int identity(11)noOfDay int [ Year ] int ) insert into #temp1 select * from # temp order by 1 asc insert into #temp2 select * from # temp order by 1 desc select noOfDay[ YEAR ] from #temp1 union all select noOfDay[ YEAR ] from #temp2 drop table # temp drop table #temp1 drop table #temp2 it return out put as

Pankaj Kumar Choudhary · Answer

Hello! Balaji try this solution....... DECLARE @Tab AS TABLE ( No Int Years Int ) INSERT INTO @Tab SELECT 12001 UNION ALL SELECT 22002 UNION ALL SELECT 32003 UNION ALL SELECT 42004 DECLARE @Temp AS TABLE (Ser int IDENTITY(11) No Int Years Int ); INSERT INTO @Temp SELECT t2.Not2.Years AS dem FROM @Tab t2 ORDER BY t2.No ASC INSERT INTO @Temp SELECT t2.Not2.Years AS dem FROM @Tab t2 ORDER BY t2.No DESC SELECT t1.Not1.Years FROM @Temp AS t1

balaji palani · Answer

Hi Dharmesh Singh Thanks for your ans!. I need a dynamic query I'm not like to insert static( (1 '2001' )(2 '2002' )(3 '2003' )(4 '2004' )).