Hi Team, Here I am posting a request for running sql queries in excel macro. I have listed my queries below. Currently am running these queries manually. I want these queries needs to be run automatically.
SELECT distinct AMRCostCtr FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs] a,[SRT1].[RequestToolDev].[dbo].[ReqMain] b where a.ReqID = b.ReqID and MainRequestNumber = '353817' If the above query does not return a result then it should automatically run the second query and then second query as shown below. SELECT StationBranch FROM [SRT1].RequestToolDev.dbo.ReqAMROOS WHERE ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain where mainrequestnumber = 353817) if the above one fails then it should run for the third one which is given below. SELECT BillableStationBranch FROM [SRT1].RequestToolDev.dbo.ReqAMRIMAC WHERE ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain where mainrequestnumber = 353817) Please help me to get this done. Thanks, Sharma Krishnan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
