Re: Nested Updates using SQLCLIENT classes

BK wrote:
Here are my questions - I know without seeing the code it might be a
bit difficult - but this is a ADO forum and I am not expecting any
help in a VB.NET perspective.

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.


1. From what I explained, does it feel that I am approaching the
solution in a wrong way?

I probably would not have done it your way. I tend to go for set-based
operations if possible. It takes a lot to convince me a set-based operation
is not possible. Ican't make heads-nor-tails of your explanation so I cannot
say if a set-based operation is possible in your situation.

2. Can this algorith be implemented in T-SQL?

Most likely.

3. Is a CLR stored procedure a better approach?

I don't know. Probably not.

4. For those of you who recommend T-SQL, what/which literature can
you refer me to that shows such Iterations, Loops, Cursors, Updates,
Transactions etc.
Again, you are avoiding set-based solutions. However ...
SQL Books Online (BOL) - they come with SQL Server and contain a wealth of
information

Also, how would you monitor the process? There are
no progress bars :) or Threads.

SQL Profiler? Or are you talking about displaying progress to a user?


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: Using parameters with the low level ADO API, trying to avoid the memory leaks.
    ... MS ADO passes SQL directly to OLEDB provider. ...
    (borland.public.delphi.database.ado)
  • Re: Programmatically changing a SQL view in a ADP
    ... One of the differences between DAO and ADO is that DAO combines data ... there isn't a way to do this successfully with ADOX. ... But T-SQL, SQL Server's ... Dim cn As ADODB.Connection ...
    (microsoft.public.access.modulesdaovba)
  • Re: Brand Spankin Newbie ADO.NET Question
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > examples in my Apress book "ADO.NET and ADO Examples and Best Practices" ... > Microsoft MVP ... > Please reply only to the newsgroup so that others can benefit. ...
    (microsoft.public.vb.database.ado)
  • Re: Smartest way toa add records manually
    ... class modules to represent tables, collections, etc., and started isolating ... we've transitioned from Access as a back end to SQL Server as ... Then I discovered why I transitioned to ADO. ...
    (microsoft.public.access.adp.sqlserver)