|
i have these 9 tables and want to calculate totalcredit from these tables alse want to
See more: SQL-server-2008R2
i have these 9 tables and want to calculate totalcredit from these tables alse want to calculate totaldebit of all account no in which each accountno will show its own total credit and total debit
parties
purchase
purchase body
purchase return
purchase return body
sale
sale body
sale return
sale return body
|
|
|
|
|
Good luck!
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-----
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
Here you might useful help for your problem: Link[^]
|
|
|
|
|
Coding is all about details.
Which means you have to look carefully at what exactly you are doing.
And be able to read, of course.
What does it say at the top of this page?
"if you need specific help please use the programming forums."
So, do you think you are able to read? Capable of noticing details? Because so far the evidence is that you can't, or don't.
Try here: http://www.codeproject.com/Questions/ask.aspx[^] but read everything carefully first...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
You may add a line about search - between 'read' and 'QA' 
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Yep just down the same thing yesterday, pretty complexy stuff, now if I was to break my NDA I would give you the code...
|
|
|
|
|
purchase return body
Are you Frankenstein's accountant?
|
|
|
|
|
|
H2G2 references get a mandatory up-vote
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
probably Playboy mansion table names   parties,purchase,sale "body"
|
|
|
|
|
We regret to inform you that your application for credit to purchase a new body has been denied; your balance is imbalanced, and we are unable to accept your existing body for re-cycling, and credit your account, because the way you have used the body you are now in violated our Terms of Servitude (TOS).
Wishing you a nice day, Satan
«OOP to me means only messaging, local retention and protection and hiding of state-process, and extreme late-binding of all things. » Alan Kay's clarification on what he meant by the term "Object" in "Object-Oriented Programming."
|
|
|
|
|
There's a query for that;
SELECT answer FROM CodeProject.Lounge WHERE question-in-wrong-area
New version: WinHeist Version 2.1.0
There's a fine line between crazy and free spirited and it's usually a prescription.
I'm currently unsupervised, I know it freaks me out too but the possibilities are endless.
|
|
|
|
|
Mike, that query didn't return anything useful?
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
Did you execute it while standing on on leg in the rain at noon on Tuesday? 
New version: WinHeist Version 2.1.0
There's a fine line between crazy and free spirited and it's usually a prescription.
I'm currently unsupervised, I know it freaks me out too but the possibilities are endless.
|
|
|
|
|
No!
Nor do I intend to!
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
You mean we can't do that at all in Phoenix? 
|
|
|
|
|
The noon thing was EST so in Phoenix you would have to do it at 9AM to get the same effect.
New version: WinHeist Version 2.1.0
There's a fine line between crazy and free spirited and it's usually a prescription.
I'm currently unsupervised, I know it freaks me out too but the possibilities are endless.
|
|
|
|
|
|
You can substitute Tequila for rain but can't guarantee same results.
New version: WinHeist Version 2.1.0
There's a fine line between crazy and free spirited and it's usually a prescription.
I'm currently unsupervised, I know it freaks me out too but the possibilities are endless.
|
|
|
|
|
So someone hit Sony with a rootkit, eh?
As one of the millions who had to clean a Sony rootkit off his computer, I say: Well Done!
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Couldn't happen to a nicer ....
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Said no one ever. Oh, except my father. Just now. 
|
|
|
|
|
ROFL... but it just works!! 
|
|
|
|
|
Except when it doesn't
|
|
|
|
|
Why does he need the Internet?
He can just sit and gaze at his beautiful mac.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
