Thanks Scott

I had not thought about the order. Didn't know you could have more than one trigger for an action.

I'm going to stick with the AFTER trigger.

On real data I'd...

Thanks for replying

dwain.c I hadn't thought of that

Jeff There are no pre-existing triggers.

I tried the periodical job but it takes ages to run. I'd expected first time to run to...

Thanks

What about making use of the fact that it will always be inserting new records and very rarely having to Update exisiting

Would this Pseudo Code be better (if I could...

Thanks Jeff

The DB containing tblcustomer is already SIMPLE. Quite a few indices as well.

I was just wondering if an SP would be quicker.

It probably needs turning into an IIS...

Thanks Daniel that's what I was thinking. Virtual Log Files, see the article

Michael that's where I read about VLFs, don't pretend to understand everything, but I can see our tran...

Hi

If I add the image file to the reports section in the solution. "Add existing item" and select an image.

It is available in the drop down when I choose...

Thanks Jack..

That was my plan, but I want something I can test in my dev environment first. The important part for me is not having to change the rdl files...

I've found the Answer. sorry.

I increased the row height.

After a Customer with a long name in words e.g.

"My Little cat has chewed my socks Incorporated" it did not display the...

Thank you Lynn

(I have a directory "UseFullSQL" it has made it into there )

I've had a quick go at it and it does what I want. I've imported my...

@SSCrazy

Thank you.

I see so in that case it always finds last char.

@luis

It was the only thing I could think off, my pc would have been hit. I'm importing...

Nice one..

Why date_input + '0'

I think it works without concatenating '0' at the end?

Thanks

My func will look like something like this

set dateformat dmy

declare @Date varchar(max) = ' Fri 14/01/2009'

declare @processed date

declare @iPos int = charindex(' ',@date,1)

SET @processed = RIGHT(@Date,LEN(@Date) -...

Point taken, up until now all CSV have been generated by running queries on remote SQL servers.

The stuff I'm dealing with now, I'm not actually sure of how it is...

select * INTO tblCustomer_new FROM tblCustomer WHERE 1=2

Will create a new table tblCustomer_new, with no rows in it

You will have to check if table exists first and drop it.

Check...

Thanks. I'll go for that

I wish I had better version than workgroup edition, scheduling reports as Excel attachments via email - is such a great idea