"cooltech77" <cooltec***@discussions.microsoft.com> wrote in message
news:A5E844AC-7EC1-4A37-9498-3333DAA7EDFB@microsoft.com...
> Hi,
>
> I need to do the following.
>
> 1)Query a locally stored MS-Access table based on date.
> 2)Create 2 temp tables in SQL Server 2005 express edition(installed on
> local
> machine) called #yesterday and #today(which contain data for yesterday and
> data for today)
> 3)Compare each row and each column from #yesterdy and #today
> using binary_checksum to find which rows have changed.
> I have used Binary checksum in SQL server 2000 but I dont find any such
> functionality in SQL Server 2005.
>
> Please help me how I can do this as I am new to SQL Server 2005 or are
> there
> any better ways of acomplishing this.
>
> Thanks
>
>

"Jerry Spivey" wrote:

> Check out:
>
> http://msdn2.microsoft.com/en-us/library/ms173784.aspx
>
> HTH
>
> Jerry
> "cooltech77" <cooltec***@discussions.microsoft.com> wrote in message
> news:A5E844AC-7EC1-4A37-9498-3333DAA7EDFB@microsoft.com...
> > Hi,
> >
> > I need to do the following.
> >
> > 1)Query a locally stored MS-Access table based on date.
> > 2)Create 2 temp tables in SQL Server 2005 express edition(installed on
> > local
> > machine) called #yesterday and #today(which contain data for yesterday and
> > data for today)
> > 3)Compare each row and each column from #yesterdy and #today
> > using binary_checksum to find which rows have changed.
> > I have used Binary checksum in SQL server 2000 but I dont find any such
> > functionality in SQL Server 2005.
> >
> > Please help me how I can do this as I am new to SQL Server 2005 or are
> > there
> > any better ways of acomplishing this.
> >
> > Thanks
> >
> >
>
>
>