So I've got this temp table in a stored procedure.<BR><BR>Here's some code:<BR><BR><pre class="ip-ubbcode-code-pre"><BR>Set @i = 1<BR>While @i <= 10<BR>Begin<BR>If ...
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 ...
Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...