vendredi 24 février 2017

Trigger for multiplication of one table vale into another table value

This will be displayed in a monospaced font. The first four spaces will be stripped off, but all other whitespace will be preserved.

Markdown and HTML are turned off in code blocks:
<i>This is not italic</i>, and [this is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

The $ character is just a shortcut for window.jQuery. If you want to have a preformatted block within a list, indent by eight spaces:

  1. This is normal text.
  2. So is this, but now follows a code block:

    Skip a line and indent eight spaces.
    That's four spaces for the list
    and four to trigger the code block.  I have two tables 
    
    

    FirstTable is

    Id || EB || EBC || DG || DGCost

    1 || 10 || Null || 10 || Null 1 || 5 || Null || 20 || Null 2 || 20 || Null || 10 || Null

    and Second Table Is

    Id || EbCost || DGCost

    1 || 2 || 3

    2 || 3 || 6

    and when i insert values in firsttable these (EbCost,DGCost)values multiply with secondtable (EB,DG) and the reult will be update in (EBC,DGC) columns corresponding with ID final output look like

    Id || EB || EBC || DG || DGC

    1 || 10 || (10*2)=20 || 10 || 30

    1 || 5 || 10 || 20 || 60

    2 || 20 || 60 || 10 || 30


    I need Query Urgently.. can any one help me here

Aucun commentaire:

Enregistrer un commentaire