no clustered index exits on table.What I want is to load the file data as it is into the table...order of records in file should match the records in table.

I...

Hi,

I suspect u are having 2 problems here .1)Trasfering data from each table(DIFFERNT SINGLE COLUMN).

2)Calculations in final table.

If so then ur first problem can be solved with unions and the...

am not sure if u r asking for the solution like inserting from 3 different tables column data into one final table column.

If yes its simple by one go with...

Are you getting each row inone column or your table columns are getting splitted?

Have you tried in xls file like @query_attachment_filename = 'bank.xls'.

and you can findout the reason..colud be the...

Hi,

I hope u can try trapping the error in try/catch block of your trigger and then display the required error either by storing in a log table or directly.

srihari nandamuri

I agree for not just simply removing the unused indexes...

But we can have sql code scan of these index/columns usage and decide why they are and how useful they are.

I...

Below is the best in sql2005

SELECT object_name(object_id) 'Table_Name', SUM(row_count) 'Total_Rows'

FROM sys.dm_db_partition_stats where index_id <2 GROUP BY object_name(object_id)

ORDER BY object_name(object_id)

/*1)Below query is to Findout the Missing Indexes on the tables.

This will generate the Create Index script based on the queries that are executed on the server by checking the...