Hi Dan, I use Stored Procedures to do the processes that involve large sets of data (> 5000 records) We all know how well the @While and @For are in speed? Like merging 1/2 million records with a 1 million record table.
You can also create a stored procedure which is a Left Outer Union Case Join ;-). What I mean is that you can create some pretty awesome select statements that you can use to retrieve from. Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:09 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: SQL Learning recommendations List, I am looking to learn more about MS SQL. Since I use Witango for almost all my work with the MS SQL is it worth learning more about stored procedures and XML and HTML and/or extending my knowledge of transact SQL. There are two new books by Ken Anderson that look good but I am not sure if they are worth getting The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM) by Ken Henderson Usually ships in 24 hours Date Added: December 7, 20 The Guru's Guide to Transact-SQL by Ken Henderson Usually ships in 24 hours Date Added: December 7, 2003 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
