Hi, ı am Osman from Turkey. I am interested in MICROSOFT SQL SERVER MANAGEMENT STUDIO. I need some help about SQL SERVER. I try to automatize my reports . I have 365 databese TABLE in SQL SERVER and ı have 36 piece stored procedures in existing Excel file, Microsoft Query connected with SQL. I want that SQL Server copy my existing EXCEL file then run 36 stored procedur then put the query report in it then put the file output destination. I need an SQL CODE for this automation. I search but not find an answer. I HAVE QUERİES LİKE DOWN. SELECT * FROM dbo.010190 WHERE FLOWER='PİNK' NOW I JUST WANT TO CHANGE AUTOMATİCALLY "dbo.010190" in every query. Because other query will be executed from dbo.020190 and other 030190 and so go on. Is there a solution for this to make it automatically. THERE IS SOME CONSTRAINTS. 1. ALL DATABASE TABLES IN SQL HAVE DIFFERENT NAME. 2. EXISTING EXCEL FILE IS NEVER CHANGED AFTER QUERY AND REUSED FOR THE NEXT EXECUTION. 3. EXISTING EXCEL FILE ARE WRITTEN TO DESTINATION FOLDER AFTER NEW QUERY REPORTS. 4. AND I WANT IT BY PRESSING ONE BUTTON.��(I HAVE VISUAL STUDIO TOO ON MY PC) 5. IF I CAN’T SOLVE IT, I MUST SPARE MY TIME SO MUCH FOR THIS PROCEDURE. IF YOU HELP ME ABOUT THIS SUBJECT, I WILL BE VERY HAPPY. OUR DEAR SOFTWARE ENGINEERS HAVE ABSOLUTELY FIND A SOLUTION TO THIS ISSUE. I AM WAITING FOR YOUR ANSWER. THANKS FOR YOUR SINCERITY AND HELP. ��












