Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
SqlStr ="SELECT DispatchNote, Serial, UsrUpdated, StockCode, SalesOrder, Updated FROM dbo.tbl_SerialNumbers " SqlStr = SqlStr & "Where DispatchNote = '" & Dnote & "' And Serial = '" & Seri & "'" Set Rst = dbConnect.Execute(SQLstr) If Rst.EOF = true then SqlStr = "Update tbl_SerialNumbers " SqlStr = SqlStr & "SET DispatchNote ='" & Dnote & "', Serial = '" & Seri & "', UsrUpdated = '" & Usr & "', SalesOrder = '" & Sord & "', Updated = getdate()" Set Rst = dbConnect.Execute(SQLstr) end if
|Export data with an insert trigger to a linked server||20||21|
|sql calculate averages||18||30|
|Need help writing 2 Insert Query Scripts in SQL Server 2012||4||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!