GilaMonster,

How does your DateWeekEnds function work? Suppose I'm using the SQL Server 2000 defaults and @@DATEFIRST=7 (Sunday). If today is a Monday and I pass in today's date, the return...

Say Table1 looks like this:

Time1          Key1

<Binary>       1

<Binary>       2

<Binary>       3

<Binary>       4

<Binary>       5

and Table2 looks like this:

Time2          Key2

<Binary>       1

<Binary>       2

<Binary>       3

<Binary>       4

<Binary>       5

where Time1 and Time2 are timestamps.

The following method will correlate...

If you are using Excel to read the data, in the Text Import Wizard, step 3, tell Excel that you want to import the column as Text. Then, Excel will...

Check this page: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224370. I'm not sure if it's the answer or not, but RPC may not be running on your machine.

select sin(0)

returns 0. So does

SELECT sin(aSIN(0))

It worked.