I'm familiar with how to loop through records in .net using a recordset but how do I do it in SQL.
I have a view with a bunch of records. each record must be inserted into another DB (mdb), but each record needs to be tested before it is added to the mdb.
here's my seudo VB code example:
while view not EOF
if view!name = null then
Add_Customer view!name (a function that adds the new customer to the mdb with the name field as a param)
insert into tblInvoices (name, amopunt, taxes, so on) .......
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …