All,
I am new to SQL Server. I have heard about this wonderful thing called stored procedures :-). I am trying to convert an Access database to SQL server 2005. I can use the upgrade wizard for the tables, but the queries that are used i cannot.
In the Access database we have queries that are built up of other sub queries, because in Access you cannot have multiple select statements in a query. However in stored procedures i think you can, please tell me you can?!?!
What i want to know is how?
I have followed a basic article through and think i can make a stored procedure select a table, but then how do i do a select using the results of the previous select?
I hope this makes sense.
Thanks,
Daz
Start Free Trial
