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.
Author |
Topic |
srisha
Starting Member
38 Posts |
Posted - 2013-06-21 : 03:36:03
|
i want to running total after opening balance--------------------------BYSRISHA |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
srisha
Starting Member
38 Posts |
Posted - 2013-06-21 : 03:49:17
|
numberVar bal;if(recordnumber = 1)then bal={@main}+({@Debit}-{@Credit});else (recordnumber > 1)then (bal+({@Debit}-{@Credit}));--------------------------BYSRISHA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-21 : 03:53:19
|
Are you expecting a t-sql solution? Above posted code is not t-sql------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
srisha
Starting Member
38 Posts |
Posted - 2013-06-21 : 03:58:57
|
no expecting ms sql only--------------------------BYSRISHA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-21 : 04:03:59
|
quote: Originally posted by srisha no expecting ms sql only--------------------------BYSRISHA
thats what i askedms sqls programming standard is transact sql or t-sql your posted didnt resemble t-sql syntax (use of { etc)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|