Thanks for your help, Matt !

I take your advice on risk. However, the source being Pubmed, chances that the file is corrupt are tiny. In other words, you cannot...

OK, so if the problem is not having the scripts, here's the SP. I was trying to help.

Now: I know what my code does (read a file, put it into...

Thanks Alan. I get you've got a much higher XML level, but I simply cannot to redesign the whole SP (lacking expertise on that !!). What I'd appreciate is some...

Thanks Jeff!

I wasn't expecting an answer now, but it's still useful. I'll definitely test it in my system.

It depends on what it does. There are literally hundreds of barcode formats, even inside the 128 format there are are multiples ways of calculating the output of a given...

Thanks, but as I said, I thought there could be another method (ideally, SQL referencing the server name).

Is this possible?

Thanks, I'm still getting my head around it, I'm going to try it right now.

I've never used a CROSS APPLY, but I guess this could be translated (done) also using...

Hi Chris,

Thanks for the advice... I tried a left join in the first place, but it didn't work.

Here's my 2 tables:

CREATE TABLE [dbo].[lkpWeeks](

[ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

[WeekNo] [int]...

By not initialiased I meant with no value in them, ie. Null. When trying to connect ad update one of the 'other' fields, that would cause an error.

Deleting (or assigning...

Seems to be that in the table I've got 2 'bit/binary' fields not initialised.

If you delete them (or initialise them), the update is fine.

Thanks, advice always appreciated anyway!!

Hi Sean,

In Access the primary key is VolunteerID, just as in SQL-S. It's just a table linked from SQL-S into Access.

The situation is:

-I can delete records directly in SQL-S.

-I cannot:...

The odd thing (from an Access point of view) is that the row, to me, is identified by the condition.

Essentially what I was doing was used some VBA on Access...

Thanks Sean, I've modified the data type from text to a limited varchar + added an ID column. This last amendment now allows me to delete records, which was exactly...

Hi Sean,

Thanks, that helps, but could you complete it?

So let's say you've got a string var 'X' and want to return the function result there. Would this be the code...

I just didn't think of it, but thank you. I've checked the TRUNCATE command and apparently one of the best things about it is that it doesn't fire the triggers...