Hi Emma,

It's nice to see someone ditching Oracle for SQL Server 2000.

My recommendation is to keep things simple for a start and that means MDB. The following...

Hi,

I don't know if you can do this with T-SQL code but you may want to create a temp table with an identity field. When you fill the table...

Hi again,

My previous post wasn't totally accurate. I did some experimentation within SQL Server Query Analyzer and found that, even with the default of NULL, I had to provide...

Hi folks,

I want to thank you all for your input on this subject. My only objective in this case was to create an INSERT stored procedure that would handle...

Hi,

I will have to try the last two suggestions and then let everyone know how they worked out.

Thanks,

Mike

Hi,

strINSERT = "INSERT INTO tblPerson ( "

strSELECT = " SELECT "

...

Hi gunnykiln,

Should you change "set @filename = contsupp.address1 + contsupp.address1" to "set @filename = contsupp.address1 + contsupp.address2"?

Mike

Hi gedeon,

In the table PersonelID is the key. Add a field for the PersonlID of the person's supervisor. That field will be related to the key field. ...

Thanks Andy.

It's too bad! That's one less reason to use stored procedures - at least for single record inserts.

It looks like the code will have...