Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
The procedures can be deployed on the master database with the included rakefile (or just manually open them in SQL Server Management Studio and run them on master) Once they are deployed you can call ...
Anyone have any idea how I can convert this to a Access query: (Mainly how do I declare variable and a table???)<br><br><br>CREATE PROCEDURE GetProductsInCategory<br>(@CategoryID ...
The procedures can be deployed on the master database with the included rakefile (or just manually open them in SQL Server Management Studio and run them on master) Once they are deployed you can call ...