Great piece of javascript mixed with CSS enlarges a thumbnail in response to a click. It greys out the rest of the screen and shows the whole image. Hardly any programming required too!
http://www.huddletogether.com/projects/lightbox/
Archives for January 2006
Executing Stored Procedures within Stored Procedures (sprocs)
Is it possible to execute a stored procedured within another stored procedure? According to this thread, it appears so. I’ll have to try it out.
Within a stored procedure, you can execute a stored procedure via EXEC OwnerName.StoredProcedureName. Check SQL Server Books Online for details on executing stored procedures. If the stored procedure returns a result set, then you can:
CREATE TABLE #Temp…
INSERT INTO #Temp…
EXEC dbo.SP1 @parm1 = 10
…
DROP TABLE #TempTara Kizer
aka tduggan