Declare @num_hours  Integer
Declare @num_minute as Integer
Declare @num_sec as Integer

	
SELECT file_name, org_rcvd_dts,
        DateDiff("s", bld_start_dts, bld_end_dts)  AS Batch_time, 
        DateDiff("s", cnv_start_dts, cnv_end_dts)   AS Build_time 
FROM   build_log(nolock)

SELECT file_name, org_rcvd_dts,
        DateDiff(hh, bld_start_dts, bld_end_dts)  AS Batch_time, 
        DateDiff(hh, cnv_start_dts, cnv_end_dts)   AS Build_time 
FROM   build_log(nolock) 
WHERE  status

package amz;

import java.util.Random;
import net.NetworkingTask;
import graph.SearchGraph;
import matrix.MatrixMultiplication;

  <add key="DB_CONNECTION_STRING1" value="User Id=cimmgr;Password=cimmgr;Direct=true;Data Source=cimdev.world;Port=1521;SID=cimdev"/>

      public void InsertintoDB()
        {

            string strSQL = "";
            string strDBType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
            string strConn = System.Configuration.ConfigurationManager.AppSettings["DB_CONNECTION_STRING1"].ToString();

     private void InsertintoDB()
        {

            string strSQL = "";

            string strDBType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
            string strConn = System.Configuration.ConfigurationManager.AppSettings["DB_CONNECTION_STRING1"].ToString();

Private Sub Command1_Click()
Dim a As String
Dim b As String
' = "TFSGNT-SAH-CMP-PreMeas"
a = "ILD-SAH-CMP-Meas-5P25K"

Dim ar
'Dim br
Dim intcnt As Integer
Dim firstStr As String
Dim secondStr As String
Dim abc As String

ar = Split(a, "-")
If UBound(ar)

TFSGNT-SAH-CMP-PreMeas
ILD-SAH-CMP-Meas-5P25K

TFSGNT-SAH-CMP-PreMeas

TFSGNT

ILD-SAH-CMP-Meas-5P25K

ILD-5P25K

   If colVIDRemark <> 0 Then
         Set dicVIDRemark = colVIDRemark.Item(i)
         strRemark = dicVIDRemark.Item(KEY_PATH)

 	 response.write "<td align=center><img border=0 src=images/delete.gif alt=Delete onmouseover=this.style.cursor='hand' onmouseout=this.style.cursor='default' onclick=getcell('d','" & rsct("ID") & "','"

    response.write "<tr><td align=center><input id=lotowner_" & rsct("ID")[B] & "&value&=" & [/B]rsct("VALUE") & " size=20 style=text-align:left>"

set rsfb = server.CreateObject("ADODB.RECORDSET")
sql = "select ID,title,value,updateby,updatedate from EMPLOYEE where title='lotowner'"
set rsct = cn.execute(sql)
maxid = clng(rsct("ID"))

function getcell_edit(x){		


		//EDIT - pass the new qty as well
		if (document.getElementById(x+'|editqty').value==""){
			alert("Please enter quantity!");
			document.getElementById(x+'|editqty').focus();
			return;
		}		
		if (!/^\d*$/.test(document.getElementById(x+'|editqty').value)){