Comments by XRushdy - CodeProject

XRushdy 17-Nov-18 16:04pm View

Sir i'm so grateful, it worked.
my old query that joining the table to itself was too much complexed and i was worried about it,
the table already contains more columns, i just tried to show a simple example of the idea and know experts opinions about the database design, that idea of (SUM(InventoryAdded) - SUM(InventoryRemoved)) will affect on performance in the future when the table gets larger?

XRushdy 5-Jan-18 12:07pm View

i'm working on win 8 64bit and filesystem NTFS, is that means that my database have no limits?

XRushdy 2-Jun-17 14:58pm View

Thank you so much, it was very helpful

XRushdy 2-Jun-17 2:19am View

And just make the two columns(Bill_ID) are the same integer number? And when retrieving specific Bill content search in content table for records that carries the Bill_ID value? Is that indexing that you talked about?
One last thing, can you please explain in a few lines what you mean by “ Also do use surrogates as primary keys” or just apply this theory to my example that I talked about).
Finally I want to say again that I appreciate your respond it was so helpful and any other instructions you can say about this example I will be grateful to read.

XRushdy 2-Jun-17 2:19am View

And Bill content table be like:
Some AutoNum&PrimaryKey \ Bill_ID \Product_name \Brand\etc.

XRushdy 2-Jun-17 2:18am View

Bill table be like:
Bill_ID(AutoNum&PrimaryKey) \ Date \ Client_ID \ notes \ etc.

XRushdy 2-Jun-17 2:18am View

I really appreciate your help, this exactly what i need.
Obviously you understood my question very well
So you've pointed me to some valuable informations that i always needed, not just in this project.
And I know that my question is primitive (just generic informations) but i doubted that anyone will understand what I meant
Now you say this is the right way to deal with big database: two tables for example

XRushdy 2-Jun-17 0:38am View

Deleted

and what you said is: i should avoid inserting texts to database as much as possible
so i should create a table for common texts like "sales bill, deposit in bank , salary, rent"
then when insert a new record in daily log table replace operation description cell with ID of this operation type from common texts table, right?

XRushdy 2-Jun-17 0:14am View

Deleted

Even though what you said in the first of your comment that my question is hard to be answered, but you pointed to some important points that will be considered while building the project, your comment is exactly what i asked for

XRushdy 16-Feb-17 11:02am View

is there a way to save those medicin names in prescription column in patient table?

XRushdy 16-Feb-17 11:00am View

the situation is i got a clinic project, every patient has a prescription must be in his record, this prescription will contain multi strings(medicin name per line), now i'm looking for good way to do this

XRushdy 16-Feb-17 10:55am View

yes, but u're right, i feel that it will be bad design, so i'm looking for another idea

XRushdy 10-Feb-17 3:07am View

And what exactly is HIPAA?

XRushdy 20-Sep-13 3:16am View

Thank you very much Mehdi Gholam,
It's working.
I'm trying to solve this error for days,but now it's solved.

Comments by XRushdy (Top 14 by date)