Well currently it would be a once a month job or something around that frequency.

Thank you for the help,

Oliver

It would be good to have:

note id product code

1 ...

Thank you, this makes sense, will give it a go and see how far we can get.

Many Thanks,

Oliver

spot on, this is exactly it, didnt think to use patindex.

Many Thanks for your help,

Oliver

Thank you for your help, exactly what I needed, now works like a dream.

SELECT * FROM GC_HEADER d

cross apply dbo.REGIONINTERSECTTABLE (d.GC_HEADER_ID,d.LATITUDE,d.LONGITUDE)

where LATITUDE is not null and LONGITUDE is not null

GO

Cheers,

Oliver

Thanks for your help on this I will try the ADO.NET route, at the moment I am working with dynamic sql and the table data type.

Cheers,

Oliver

hi,

use this

http://msdn.microsoft.com/en-us/library/ms187748.aspx

to build up you lengths and then use left() and right() as required. Reverse() can also be really useful.

Cheers,

Oliver

thanks for the help

thanks for the help, changed the code to this and success.

Many Thanks,

Oliver

UPDATE dbo._SSA SET xml_data.modify('replace value of (/resRefDate[1]/refDate/text())[1] with xs:string(sql:variable("@dTxtPubdate")) ')

UPDATE dbo._SSA SET xml_data.modify('replace value of (/resRefDate[2]/refDate/text())[1]...

I forgot to say that the node is preceeded by

/metadata/dataIdInfo/idCitation/

Many Thanks,

Oliver

Found a way around using xp_cmdshell, very happy. borrowed lots from others.

Cheers

DECLARE @filename VARCHAR(255)

declare @RowNum int,

@CustId nchar(5),

@Name1 nchar(25)

select @CustId=MAX(ID) FROM _SSA --start with the...

read up a bit found out its not possible to do suffix seaching

only option would be to reverse and carry out the wilcard.

nevermind

Thank you very much, the query now takes less than a second instead of 5-6 seconds.

Kind Regards,

Oliver

many thanks for the response.

After generating the scripts do you then use visual studio to create the installation package?

Many Thanks,

Oliver

Thank you very much for your replies I am much clearer now on this. Really appreciate it.

Obviously the code writer was being extra thorough when writing the script.

Many Thanks,

Oliver