Re: combine recordsets

Tech-Archive recommends: Speed Up your PC by fixing your registry

So instead you'd rather reinvent the wheel, and try to do the job the
SQL database engine was designed to do?
Frankly, I never understood the prejudice against creating "additional
server proc's". If I were doing this, I would create a procedure that
inserts the results of those two procedures into temp tables, then do a
join and return the combined results.

But ...

I see you posted code in your original post, and it appears that it
should do what you want, i.e., add fields to the new rs that are not
already in the rs.
What is the problem with what you posted?

jamesfreddyc wrote:
Bill,

rs1 and rs2 are already coming from complex SProcs on SQLServer. I
don't want to add additional server proc's, I just want to combine
these two recordsets for display in a DataGrid.

Thanks,

--
HTH,
Bob Barrows


.

Relevant Pages

  • Re: Pragmatically compact and repair database
    ... I think all the posted code will work. ... the mdb have to be closed by all user before the code can work. ... access2000 .mdb database stored on a server. ... installed on the server or the client computers were the vb6 app resides on. ...
    (microsoft.public.vb.general.discussion)
  • Re: uploading files to file system/zipping/downloading problems
    ... system on my server using python, just reading the file and writing the ... posted code). ... would need to be outside the loop (above the ... You should take a look at shutil module. ...
    (comp.lang.python)
  • Re: Help with Swing threading!
    ... 'server' is an instance field of the class which has the posted code, ... calculation. ...
    (comp.lang.java.programmer)
  • Re: Whats going on?
    ... Chris (Using NTL's news server.) ... Remove prejudice to reply. ...
    (uk.rec.cars.maintenance)
  • Re: Is this the day Usenet died?
    ... were saying: ... Just your server, Dave. ... Remove prejudice to reply. ...
    (uk.rec.cars.maintenance)