Hi all, 
i think i found half of my answer. 

if i make changes to tables or add tables, i need to use SP_AddArticle and SP_DropPArticle to add or...

Thanks for all the responses. its now resolved. (user error). enough said. :rolleyes:

I didn't know about try_convert which is a very useful function so at least I've learnt something new.

Thanks...

Thanks John,

I've tried using DateFromParts() and I get the same error.

,DATEFROMPARTS('20'+right(invoice_date,2),right(left(invoice_date,5),2),left(invoice_date,2)) as invoice_date

It's almost like something else is throwing it out, and not these fields. I'll keep digging.

and once I convert it, it looks like

000903642006-09-14 00:00:00.0002006-09-07 00:00:00.000

000903652006-09-14 00:00:00.0002006-09-08 00:00:00.000

000903662006-09-14 00:00:00.0002006-09-13 00:00:00.000

000903672006-09-14 00:00:00.0002006-09-07 00:00:00.000

so, not sure, why it wont accept it.

if I create an insert statement e.g....

Hi, Data looks like.

[invoice_number] [invoice_date][eta_date]

0009036414/09/0607/09/06

0009036514/09/0608/09/06

0009036614/09/0613/09/06

0009036714/09/0607/09/06

Thanks for the reply Lowell

I'll give this a go when I'm back at work tomorrow.

That was my next step, create a more robust Sp. with further checks prior to executing...

Thanks for the reply Louis, no I don't have any other processes/linked servers on this server.

This is the only one.

Hi Komal,

Is it just date format or date and time?

Example 1

You could left trim the string.

Left('2015-09-01-00.00.00.000000',10)

To get just the date,

Then to get a date format

Convert(date time,Left(2015-09-01-00.00.00.000000",10),103)

Dave

I see..

To create a heap, create a table without a clustered index. If a table already has a clustered index, drop the clustered index to return the table to a...

Thanks for the reply Jason,

yeah, they're all Zero.

I've got 12 of these little monkeys.. all on the same Database.

Thank you all for your help,,, I've found it much easier just to lookup the entry in the web page prior to writing it to the table.

Regards

Dave

I thought AFTER INSERT meant that the code ran after it had been inserted, clearly its not the case 😀

ALTER TRIGGER [dbo].[TRIG_Update_Install]

ON [dbo].[tbl_warranties]

...

Yes, I see what you mean, but that also creates another problem.

This won't work, because its looking for a record to update in tbl_warranties that doesn't exist yet.

update tbl_warranties set...

Hi Lowell,,

Yes, its not the cleanest or logical of code.. Just thrown together to get a result.

Ideally, I wouldn't...

yeah, I could have just updated the row for the individual scope ID, but there are only ever 5 records in there with a Null datefield which is being checked....