Could someone please tell me how to run a sql script several times that takes a different variable each time. I don't have create procedure priviledges on my server so I can't write a procedure. So I was trying to do the prompt thing but I can't get it to work.
So I want to select * from a table where column1 = some_variable.
I put that select statement in a .sql file but i can't get the variable to go through. Please help Thanks a lot