Click here to Skip to main content
15,443,778 members
Home / Discussions / Database
   

Database

 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 13:15
professionalMycroft Holmes20-Aug-09 13:15 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:10
MemberTheIdleProgrammer20-Aug-09 22:10 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes21-Aug-09 0:33
professionalMycroft Holmes21-Aug-09 0:33 
GeneralRe: LIKE Predicate Pin
David Skelly20-Aug-09 22:53
MemberDavid Skelly20-Aug-09 22:53 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 23:07
MemberTheIdleProgrammer20-Aug-09 23:07 
AnswerRe: LIKE Predicate Pin
Luc Pattyn20-Aug-09 4:58
sitebuilderLuc Pattyn20-Aug-09 4:58 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:11
MemberTheIdleProgrammer20-Aug-09 22:11 
QuestionSql Problem Pin
AhmedGebaly19-Aug-09 23:37
MemberAhmedGebaly19-Aug-09 23:37 
Id Credit Debit CurrentCredit Current Debit
51 21500 0 21500 0
52 0 21500 0 0
89 0 2150 0 2150
93 0 2140 0 4290
128 2140.5 0 0 2149.5
129 2151.5 0 2 0
171 0 1628 0 1626
190 1628 0 2 0


i have column of credit and debit and want to get columns of current credit and current debit
example:
51. credit=21500 and debit=0
i have credit more than debit so this increase credit and decrease debit
then
current credit = 0+21500

52. credit=0 and debit=21500
i have debit more than credit so this decrease credit and increase debit
then current credit =0 and current debit =0

89 credit=0 and debit =2150
i have debit more than credit so this decrease credit and increase debit
then current credit =0 and current debit=0+2150=2150

93 credit=0 and debit =2140
i have debit more than credit so this decrease credit and increase debit
then current credit =0 and current debit=2140+2150= 4290
and so on...
AnswerRe: Sql Problem Pin
David Skelly20-Aug-09 2:26
MemberDavid Skelly20-Aug-09 2:26 
AnswerRe: Sql Problem Pin
Kschuler20-Aug-09 3:17
MemberKschuler20-Aug-09 3:17 
AnswerRe: Sql Problem Pin
Jerry Hammond20-Aug-09 3:41
MemberJerry Hammond20-Aug-09 3:41 
Questionset row number in select query Pin
nainakarri19-Aug-09 20:34
Membernainakarri19-Aug-09 20:34 
AnswerRe: set row number in select query Pin
_Damian S_19-Aug-09 20:41
professional_Damian S_19-Aug-09 20:41 
GeneralRe: set row number in select query Pin
nainakarri19-Aug-09 20:44
Membernainakarri19-Aug-09 20:44 
GeneralRe: set row number in select query Pin
Coding C#20-Aug-09 3:36
MemberCoding C#20-Aug-09 3:36 
Questionhow to connect to magic database Pin
elimpiado19-Aug-09 19:53
Memberelimpiado19-Aug-09 19:53 
AnswerRe: how to connect to magic database Pin
Mycroft Holmes19-Aug-09 20:22
professionalMycroft Holmes19-Aug-09 20:22 
GeneralRe: how to connect to magic database Pin
Ashfield19-Aug-09 21:00
MemberAshfield19-Aug-09 21:00 
Questionhow to attatch, restore database to msde using vb.net or c# .ne Pin
Ageesh18-Aug-09 22:43
MemberAgeesh18-Aug-09 22:43 
AnswerRe: how to attatch, restore database to msde using vb.net or c# .ne Pin
Mycroft Holmes19-Aug-09 17:46
professionalMycroft Holmes19-Aug-09 17:46 
QuestionHow to calculate the total memory occupied by the database Pin
Krishna Aditya18-Aug-09 22:42
MemberKrishna Aditya18-Aug-09 22:42 
AnswerRe: How to calculate the total memory occupied by the database Pin
dan!sh 18-Aug-09 23:07
professional dan!sh 18-Aug-09 23:07 
GeneralRe: How to calculate the total memory occupied by the database Pin
Krishna Aditya18-Aug-09 23:18
MemberKrishna Aditya18-Aug-09 23:18 
GeneralRe: How to calculate the total memory occupied by the database Pin
Mycroft Holmes18-Aug-09 23:23
professionalMycroft Holmes18-Aug-09 23:23 
GeneralRe: How to calculate the total memory occupied by the database Pin
Andy_L_J18-Aug-09 23:32
MemberAndy_L_J18-Aug-09 23:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.