hey hii everyone !!! i have one urgent question, please help me for my below query so that i can make an automated tool for daily absenties people in my office. **following things i have already:** one excel sheet in which we maintain the records of daily absent employee. format of excel sheet is as follows(column wise): employee name(1st column) , employee code(2Nd column), employee's team name(3rd column), employee's supervisor name(4Th column) ,employee's leave type i.e. planned, unplanned(5Th column). we put this excel sheet in specified location. **NOW MY requirement from your side** now i want to write a SQL query that will fetch these records on two basis(1st day basis i.e. daily basis and 2Nd is time(Indian time 1:30 PM)) and send to specified peoples in my office(
firstname.lastname@example.org, etc) if anyone reply me quick with my solution that will be appreciable. Cheers shalabh
I would take a look at SSIS for this. You would define the import process, data transformation (if necessary) and finally the emailing of the data to the people needing it. A second possibility would be to do the import with SSIS and use reporting services to provide the final data report. This allows for an up-to-date call of the data, or a subscription based email delivery (whatever the user wants). That would also be a springboard for bringing in that sort of data driven analysis that may be missing in your company. As soon as people see what is possible with SSRS, they generally go crazy and want reports on everything. When that happens, take on the responsibility and become a data hero at your company!