Can someone provide suggestions on an urgent basis...

Thanks...

Thanks for the replies. I will sort this out.

In the meantime, I have found a bug in my code during testing. It relates to LongestTime field in the MainTable which...

Thanks for the suggestion Lutz, but it is not possible for me to edit the EXE as numerous other reports are produced from the SQL Server 2000 box from which...

Hi Gail,

The code provided above is the full version. What is happening after that last INSERT statement into tblMainTable is that an EXE will run and fetch the data from...

Hi Gail,

Thanks for the reply.

I have used an ORDER BY clause at the end where I am retrieving data from the Temp table (#TempStore) into the final table (tblMainTable) at...

Hi,

Im really stuck with this one, could someone help me in fixing it.

Thanks,

Sanchit

Thanks for the reply Lutz. Ive got some more info for you to better understand the Final table columns as shown below...

-- Desc for input columns in Table1..

Events - no...

Lutz here you go...

-- Sample data for Inserted into the table from which data is imported i.e. Table1

insert into Table1 values (100, 'YU345678910TH' , 'LocA' ...

Thanks for the reply Steve. Will try it out.

@Lutz - Please find the table definations and expected output as given below.

-- Table from which data is imported for calculations

CREATE table...

Just some more info..

When Date1 and Date2 are upto : '23:59:59', the query is working fine. But when it becomes '24:00:00' - I am getting Overflow error.

Thanks for your reply !

I used the below block to get the AverageTime field by adding the 2 date columns by first converting them to seconds and then dividing it...

Thanks for the reply.

I edited the script to include '+' and edited code is..

SET @sql = 'INSERT INTO ' + @table + ' VALUES(

'...