"Pascal" <anniesraar@hotmail.com> wrote in message
news:dca6bfcd.0410280827.184e8fc6@posting.google.com...
> Hi,
>
> I am completely lost. I have a stored procedure that creates a temp
> table and inserts and eventid. Afterwards other fields are gathered
> via an innerjoin. The problem is that I have a created another table
> with only the changes to these events.
>
> So
> tblEvent is eventid / eventname / eventdate / userid / eventtime
> tblEventHistory is versionid / eventId / eventdate / eventtime /
> changeDate
> tblUser is userid / username
>
> tblEvent has one record and tblEventHistory could have multiple
> records but with only the changes at a certain time.
>
> Problem is that I don't know how to create a recordset that provides
> all the records via an inner join and also get the records from
> tblEventHistory.
>
> Furthermore I have to use the records on an asp page and mark the
> changes between records. Is there an easy way to do this. Any pointers
> would be greatly appreciated.
>
> I am using the resource on
> http://www.4guysfromrolla.com/webtech/020701-1.2.shtml as a basis.
>
> Apologies for my explanation but hopefully someone will be able to
> help me out.
>
> Cheers.
> Pascal

"Manohar Kamath" <mkamath@TAKETHISOUTkamath.com> wrote in message news:<uNUU49QvEHA.1616@TK2MSFTNGP10.phx.gbl>...
> You might want to use a shaped recordset instead of a huge JOIN.
>
> http://support.microsoft.com/kb/189657/EN-US/
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com