Right-click on the archive active-X object, select 'Workflow Properties' under 'Workflow'

Select the Options tab

Tick 'Use ActiveX scripts' and select 'Properties'

Insert the following ActiveX script, and modify the filename for your needs

'**********************************************************************

' ...

rockmoose: 🙂 I'm not so hot at maths, so you win!  I was thinking along the lines of storing numeric keys in the char data.  Thinking further, if you use...

Something else to consider when designing your joins and indexes (you should preferably be joining on indexed fields), is that an Int takes 4 bytes of physical space, thus your indexes will...

I was told on a SQL cource I attended, that SQL Server 2000 is optimised for use of Int and GUID as Primary Keys, and for joining.

I haven't been able to...

You could replace the called sproc with a user defined function (UDF) which can return a temporary table.  You then use the temporary table as your result set.