SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Query ?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

53 Posts

Posted - 10/26/2012 :  07:42:58  Show Profile  Reply with Quote

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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000