Call Function from Stored Procedure

Hi All,

I'll admit that I'm not the greatest at stored procedure/functions but I want to learn as much as possible. So I have two questions:

1) I had VS2005 autogenerate a sqldatasource that created Select/Insert/Update stored procedures. When Updating a record and calling the stored procedure, I want to query another table (we'll call it tblBatchNo) that has only one record, Batchno. I want to put that current batchno into the Update statement and update the record with the current batchno. Can someone point me in the right direction? Remember that I'm still a beginner on this subject.

2) Can someone provide any links to online tutorials on t-sql?

Thanks in advance.

Curtis

Here's the best link I know of on How to Share Data Between Stored Procedures:http://www.sommarskog.se/share_data.html. Per the article, I recently converted some old procs into table variable values functions. ADO.NET reads a table variable just a table. Best of all, you can use the function from within another stored proc.

If you need info about table variables, try this link:http://www.odetocode.com/Articles/365.aspx.

HTH.

|||

Thanks! This will get me started in the right direction.

Curtis