I want to run the following procedure first: 

```
exec ep_upd_server_abc

```

Then execute the following statement:

```
SELECT * FROM dbo.Server_Warehouse 
WHERE Enabled = 'f' and disabledweekly = 'f'

```

Can I write the following procedure in SSRS Query Builder so that I can execute two statements?

```
CREATE PROCEDURE ShowDBJob
As
Begin
    exec ep_upd_server_abc;

    SELECT * FROM dbo.Server_Warehouse 
    WHERE Enabled = 'f' and disabledweekly = 'f'
End

```

Is there a work around for this?

I tried running this in SSRS Query Builder and it's giving me an error. Would appreciate any thoughts and suggestions...Thanks!!