Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Query ?

Author  Topic 

oguzkaygun
Yak Posting Veteran

53 Posts

Posted - 2012-10-26 : 07:42:58
Hello

I need SQL for compact 3.5 about below result.

I have table and colums as in and out. i need result and result kind like below.

in out result resultkind

10 0 10 In

5 0 15 In (10+5-0=15) 15=15 In

0 20 5 Out (15+0-20=-5) -5= 5 Out
   

- Advertisement -