Actually from what you typed you will get an error as no DID exists in rblHeader or tblDetail.

See Here

create table tblHeader (ID int)

create table tblDetail (ID int, MID int)

your...

I noted when test that SUM(codehere) seems to be parsed before the case is. I would report as a bug to Microsoft. They may be aware of this but always...

It depends on any indexes you have in place and if the unique idenifier is the primary key and a clustered index. If not clustered then you will get a...

Sounds like you could not connect to the server in your DTS package. How is the connection defined? It is not uncommon for some developers to forget that the name...

Steve is right, this can only be if the tables are in a DB or Ilegroup marked read only or triggers are in place to prevent changes.

"Don't roll your eyes...

Have him try this.

Dim recCnt as integer

Set snapData = DBase.OpenRecordset(sSQL, dbOpenDynaset)

snapData.MoveLast 'Read recordset into memory to get number.

recCnt = snapData.RecordCount

snapData.MoveFirst

and see if it returns.

"Don't roll your eyes at me. I...

Also the tabular data stream is not encrypted if I remember correctly. There was another thread on this here where we went into the details of this. So therefore someone...

First is this a 6.5 database? If so what is the exact message with error number I had replyied to this same question before but cannot find.

"Don't roll your eyes...

Your problem looks like @TotalAmt is a char type datatype. And the case the first time implicitly converts since 'X' is char type then 0 is interpretted as a char...

I am confused are you saying you want to submit multiple values and get the sum? If so then do your procedure like so.

CREATE PROC ip_SumAct

@activity VARCHAR(20)

AS

SET NOCOUNT ON

CREATE #tmpTbl...

See the item in SQL BOL but here are an example of each.

OPENDATASOURCE

SELECT *

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

OPENROWSET

SELECT c.*, o.*

FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0',

...

Use a trigger and look at the insert table. There you can inset to the other table based on the insert input on the one table. See CREATE TRIGGER in...

Proc Blaster has several usefull templates but there is nothing specific you can more than that with SPs as they are basicall CREATE PROC name

input/output variables

AS

your processing code.

Also another trick...

Could not find anything on this in the SPs but there are sometimes unlisted fixes in the SPs. If you have no issues that would prevent consider revising to the...

Actually can you post the code from vb (please alter security stuff)? It may be the type of cursor you are using in the recordset.

"Don't roll your eyes at me....