SQL - Run Query issue

Help StudioX
,
1

I am trying to run a simple select query in the Run Query activity and display the results in a message box. I can connect to the db fine. I verified that the query runs fine in the native db fine. The scr shot is my set up. I have tried the select statement with single quotes and double quotes. The error I get is:

Could not find stored procedure ‘SELECT top 10 * FROM auth_den_ltr’.

This is not a stored procedure I am trying to run. Just the simple direct select statement

image
image1366×728 61.4 KB

If I run the query with NO quotes, I get this message box with the phrase str_text

2

@scott.doscher

Please follow this

remove the run query…add a new one

click on plus icon beside edit query

select open advanced editor

and then give the query with double quotes "SELECT top 10 * FROM auth_den_ltr"

then save and run(Try removing top 10 just to check)

and I hoep you selected command type as text

image

cheers

3

I think ur query looks fine
Usually we put in double quotes only

Try to upgrade the database activity package in Manage Packages option and give a try

Or

Restart your machine and studio and try again

Or

Recreate the same activity with same details and try

Cheers @scott.doscher

4

Thank you @Anil_G. That worked. It was that I needed to work in the advanced editor. I appreciate that.

1 Like
5

Thank you so much @Palaniyappan. I greatly appreciate your feedback and support.

1 Like
6

@scott.doscher

Glad it helped you

Happy Automation

Edit query and Advanced editor works little different…I personally prefer the later :smiley:

cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.