Re: combine recordsets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

Yes, I completely understand and would if I could. However, this particular
SQLServer db is running ArcSDE (Spatial Database Engine, and ESRI product for
the Geographic Information Systems software). If you have ever had to work
with this special database, aka.. "GeoDatabase", you would find that it
manages all of the tables registered with the ArcSDE with it's own
specialized functions.

One huge problem is it's internal ObjectID creation/population that occurs
across the entire database --- this is something that simply cannot be
manipulated, and as such, CREATE TABLE # commands would cause serious issues.


Perhaps I could opt for creating/using a db not participating in the ArcSDE,
but I simply don't have the access/permissions/opportunity to do so.

But, thanks for the input, I will take a closer look at why my original code
failed.

thanks,

j

"Bob Barrows" wrote:

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: Cannot log out of RWW
    ... However when i was at the server, and tried typing in the FQDN, which points ... and rww would get stuck on the loading screens. ... So you need only give full control permission to Temp folder. ...
    (microsoft.public.windows.server.sbs)
  • Re: Swing migration Q?: problem joining new DC to temp domain
    ... Do not disconnect the temp DC from the old domain until you see a good ... should see on the new server at \\servername. ... I dig all old source server names out of dns. ... Check your SBS with the SBS Best Practices Analyzer ...
    (microsoft.public.windows.server.sbs)
  • Re: Win2k3 -> Win2k3
    ... where I use the temp server as a DC that replicate the AD objects. ... Windows 2003 domain to Windows 2003 domain using ADMT. ... 326480 How to use Active Directory Migration Tool version 2 to migrate from ...
    (microsoft.public.windows.server.migration)
  • Re: Server Shuts Down - HELP
    ... > SORRY GUYS - SERVER Down this morning. ... The room is warm (max temp went to 90' F) this was the first ... > lastest firmware from Compaq. ... >>> latest monitoring software from Compaq. ...
    (microsoft.public.windows.server.sbs)
  • Re: Restoring Active Directory domain
    ... Is that temp DC multihomed? ... I believe you're right and the problem is in my DNS setup. ... the new temp server, I get this: ...
    (microsoft.public.win2000.active_directory)