pROB:t-sql SCRIPT TO GENERATE SCHEDULED REPORT

• • Reply

  14 years ago

  by psashi

  sashi John

  , India

  Joined 14 years ago

   

  Hi All,
  
  It would be great if anybody could help me how to write a T-SQL script to generate a report in spreadSheet from a table in SQLserver 2000 database.
  
  And this report should be generated as per the following timings(Sheduled timings only).
  
  
  
  

  As well it should be able to send a mail regarding the availability of the report to user groups.
  
  Incase if the generation of report fails then we need to send a mail reg the failure.
  
  Any HELP is greatly appreciated!!!
  
  Thanks in Advance!!!
  
  
  
  
  
  
  
  

  Regards,

  Sashi John

  Report abuse