tsql - SQL Server Row_number in odd/even number? -

-

i have question querying accounting data.

for example, sample data show below

table: table_test

date        amount   2013-01-01  12.00 2013-01-02  13.00

the output should this:

date        account        debit    credit 2013-01-01  abccompany     12.00 2013-01-01  vendorcompany           12.00 2013-01-02  abccompany     13.00 2013-01-02  vendorcompany           13.00

initially, think using union statement because may output sequece not important , sample sql show below

select      date 'date',      'abccompany' 'account',      amount 'debit',      '0' credit table_test  union  select     date 'date',      'vendorcompany' 'account',      '0' 'debit',      amount  credit table_test

output:

date        account        debit    credit 2013-01-01  abccompany     12.00 2013-01-02  abccompany     13.00 2013-01-01  vendorcompany           12.00 2013-01-02  vendorcompany           13.00

but seem after show output pic, mention wrong sequence quite important them.(used export system)

what came out mind using t-sql manipulate may provide flag isdebit , possible row_number(odd number in first sql, number on second sql union , made logic on it? possible?)

is able provide me idea how deal this?

something should work:

select  date 'date', 'abccompany' 'account', amount 'debit', '0' credit, row_number() on (order date) * 2 rn table_test union date 'date', 'vendorcompany' 'account', '0' 'debit', amount  credit, row_number() on (order date) * 2 + 1 table_test order rn

although more columns may needed in order by clauses make things unambiguous (it's tad tricky tell limited example you've given)

i've switched using union all since result sets produced distinct.


Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

-
this question has answer here: delimiter must not alphanumeric or backslash , preg_match 5 answers this question has been asked don't know how fix problem in situation. getting following php errror: php message: php warning: preg_match(): delimiter must not alphanumeric or backslash in... on line 227 line 227 following: if (preg_match($match, $_server['http_user_agent'])) and function: $oslist = array ( 'windows 3.11' => 'win16', 'windows 95' => '(windows 95)|(win95)|(windows_95)', 'windows 98' => '(windows 98)|(win98)', 'windows 2000' => '(windows nt 5.0)|(windows 2000)', 'windows xp' => '(windows nt 5.1)|(windows xp)', 'windows server 2003' => '(windows nt 5.2)', 'windows vista' => '(windows nt 6.0)', 'w...
Read more

Delphi interface implements -

-
i expect reference counting should work on outer aggregating object in interface implementation. if can refer example: clarity in classes implementing multiple interfaces (alternative delegation): here minimal reproduction of behaviour: program so16210993; {$apptype console} type ifoo = interface procedure foo; end; tfooimpl = class(tinterfacedobject, ifoo) procedure foo; end; tcontainer = class(tinterfacedobject, ifoo) private ffoo: ifoo; public constructor create; destructor destroy; override; property foo: ifoo read ffoo implements ifoo; end; procedure tfooimpl.foo; begin writeln('tfooimpl.foo called'); end; constructor tcontainer.create; begin inherited; ffoo := tfooimpl.create; end; destructor tcontainer.destroy; begin writeln('tcontainer.destroy called');//this line never runs inherited; end; procedure main; var foo : ifoo; begin foo := tcontainer.create; foo.foo; end; begin main; readln...
Read more

css - invalid property value for padding -

-
i getting invalid property value padding , don't know why. code written in ruby btw. when check browser has right value pixels, crossed out w line , isn't reading attribute. in advance. <% mywaldo = mapping::mywaldos.sample %> <!doctype html> <html> <head> <title>sinatra single-serve</title> <link href="css/bootstrap.css" rel="stylesheet" type="text/css"/> <style> div { width: 1024px; height: 768px; background-image: url("img/waldos/<%= mywaldo[0]%>") ; } #waldo { position:absolute; top: <%= mywaldo[2]%>; left: <%= mywaldo[1]%>; padding: <%= mywaldo[3]%>, <%= mywaldo[4]%>; } </style> </head> <body> <div> <a id="waldo" href="">aa</a> </div> <%= yield %> </body> ...
Read more