ok how about

CREATE PROCEDURE dbo.pUpdateStock

@StockID int = NULL,

@StockName varchar(1000) = NULL,

@Action = 0

AS

IF @Action = 0 --Insert

INSERT INTO STOCK (stock_name) VALUES (@StockName)

ELSE IF @Action = 1 AND @StockID IS...

There isn't a "class" in T-SQL but you could create one SP and just pass in an action field that states whether you are to add, edit or delete?

Silly me! Just found out from MS that there was a change in SP1 to SQL Server 2000 that changed the format of the csv file from UNICODE to ANSI...

yeah i've set the parameters to:

@attach_results = 'true',

@attachments = 'file.csv',

@separator = ','

and it doesn't seem to be able to open it properly.

if I set the separator as a TAB then...

Yeah, but it says you can only install the Developer Edition of Reporting Services on XP Professional. Anyway I didn't know that - I suppose I didn't look past the...

hi arick, as far as I know you can only install the client part of the reporting services on an XP machine. This means that you don't get the reporting...

I don't know if this is true as I havent tried to do this myself but I saw that MS were planning on doing embedded reports in the next version...

Easy, stick all of the data into a temp table (but you'll need to "create" table first and then use INSERT and then report from that table before dropping it.