Ok.
Thanks
Please ignore if this makes no sense to you .. please forgive me GRAZ
Its all .. a series of beginnings ...connections and intermediate things that are put together = the final result
at least for SQL .. subject
everybody has to do this .. for example = handicapped people or deaf and dumb people
its the same things .. but how they do the same things ... will be different ..
example = one may run 1 mile .. or other person may walk the mile .. different ways but same thing
+++++++++++++++++
You said
BTW
I don't know how to display the following in grid or excel-like which is easier for others to understand.
++++++++++++++++++++++
you can also explain like this ..
Table1 (id,value1,value2)
1, 36, 40
Table2(checkamt)
50
Table3 (result)
36, 14
++++++++++++++++++++
Explanation
Table1 = Value1 = 36
Table2 = checkamt = 50
Only 3 possibilities .. Greater than , Less Than , Equal to
Value1 > ( greater than ) checkamt
36 > 50
... if no the 36 Value1 becomes Table3 Results Value1
Table3 Results
Value1
36
What about value2
.. if 36 > 50 = no then 50(checkamt) - 36(Value1) becomes Table3 Value2
Table3 Results
Value2
14
so now Table3
Value1 Value2
36 14
I meant you gave the result as picture or image in your post 34,35
and how can i do so
You can type all that in excel
Take a computer screen shot
Open mspaint
Paste into mspaint
Save as file .png
Upload the file into your post
There is an image icon which is there
Click on it
It will ask you for file to upload
Select your .png file
Thats it
The picture is there in your post
Not cool to post images. Then we have to retype everything
Best to post ddl and dml
ok yosiasz
That discussion was about posting images of "explanation"
Yosiasz
Not about posting DDL or DMl
Please correct me if I am wrong
Mateen
Yes sort of.
I will combine DDL or DML and low size jpg for explanation and picturesque view.