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 ...
Ok, I got this SP here in SQL server. It;s like 600 lines long, so I'll spare you the gruesomness of it (I didn;t write it)<BR><BR>There are 2 values, TotalAccount and TotalProduct.<BR><BR><BR>In the ...
SQL Server 2005, now available as a "community technology preview," is an odd beast. For those who believe their databases should be little more than simple data access routines with business logic ...