or you could look at instantiating the crystal reports dll in your dts script

might be easier though to create a .net app that does the printing and then you can...

or for SELECT @result = @result + @Match

try

SELECT @result = isnull(@result,'') + isnull(@Match,'')

if you have a null value in homeTeam.Name or awayTeam.Name the soln will be null try using

isnull(homeTeam.Name,'') + ' v ' + isnull(awayTeam.Name ,'')

i have never tried what you ask for

but to partly answer your question, if you have Business Objects Server you can use the scheduling function there to produce the reports.

another...

update [main table]

set somecolumn = someCalculations

From [main table] A inner join

(select id, someLargeTableCalculations

from [LargeTable]

) B on A.someid = B.id

as has been said already post your code if you need a...

is it possible for you to tell us what this column does?

in that case I would propose you use a trigger on insert or update on the table, checking if the inserted value is null

in what circumstances

(the field may in other circumstances have a valiue other than the identity.)

you can use an expression on the column

give us all the necessary information so that we can be of better help to you

suppose your identity column is A, and you want to set B = A then

Alter Table TableName ADD

B as A

yes, you can set your column as a computed column

i have actually realised that you can also use the semi colon when u have multiple statements in a query when using sp_send_dbmail

what about creating a separate db with the required nvarchar datatypes and then do an import into it

i was about to say that, it might be better to post in an asp forum coz u will get better help there

does that mean no progress??