yes schedule a job using ssis packageto import the files but create a instead of insert trigger to make sure that only the new or changed records are added to...

yes as indicated by sqlbuddy this may happen because abnormal restart of the system or the services are not running....make sure that the sql server instance is running...and if its...

thnx jeff..... much appreciated!!!

ok ill check it out.....

with "runs fine" i meant dat it provides da required result, i wasnt pointing towards it's execution time etc...

Hey jeff, thnx for ur critical view on my code. it runs fine, i have tested it but it works for on equipment....just wanted to try another way to solve...

here u go mayn..... use this script......create a stored procedure from it wht equipment,startdate,enddate!!!!

whenever u want to populate the take for hours per day and date range....just exec the SP...

move all ssis packages manually n change the connectionstrings for each ssis package, n for jobs... script out all jobs on a single file....replace server name by using replace-all option...

kindly explain ur hours per day column.... coz its says 18 for 6:00 am n 24 for 0:00 bt on the other hand its 18.5 for 0:00...am unable to understand...

hi,

this can only b done by using date functions like datediff etc in SQL Server, dnt know about oracle .... explore them....

select Type, ISNULL([X],0), ISNULL([Y],0), ISNULL([Z],0), ISNULL([V],0), ISNULL([M],0), ISNULL([N],0)

From

(

select Type, Code, Value from TableA Union

select Type, Code, Value from TableB Union

select Type, Code, Value from TableC

) as p

Pivot

(

avg(value)

For [Code]...