I have a stored proceudre that brings back 6 columns (PART, FSC, NIIN, NAME, TotalQty, ReqID). After the SELECT statement has run, I need to update one of my tables. In the table that I need to update, there is a column named ReqStatus, and this tables PK is ReqID (from above SELECT statement). Fore...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bfancett
on
12-05-2008, 12:00 AM
Filed under: query, query?, slq 2005, Slq Server, SQL, SQL 2005 SQL, sql server, SQL Server 2005, sql server update, sql 2005, SQL Server 2005, Stored procedure sql, Stored Procedure update / insert, stored procedure variables, stored procedure variables WHERE clause, stored proceduredure sql, stored proceduree, Stored procedures, StoredProcedure, StoreProcedure, UPDATE, update column, Update SQL Statement, update statement, "T-SQL", "User Defined Function", 2005, asp.net c# profiles sql server, ASP.NET C# sql, c#, C# SQL, column attributes, column name, column name query, Data, Database, HAVING, "Dynamic SQL", For Each Loops, for loop, queries, SQL 2005, SqL For Each Loops, update records, "SQL Server", .net 3.5, db