LOL i knew it would be something stupid!!

Thanks

Hi guys,

Thanks for the help, i have tried them and can't seem to get it to work.. the error i am now getting is

Msg 156, Level 15, State 1,...

Thanks Nigel,

As it happens (for some reason) the version of Express that i have has not got the reporting services so i didn't even think of it - i'm...

To be perfectly honest not a lot - i am a self taught accidental IT bloke / DBA, i am good with crystal reports (of course no use here)

To be...

lol tried that but could not really find what i am after - everything seems to be centered around MySQL and PHP, both of which i have no experience using....

ah thats makes sense, by chance does anyone have a sample of how to run a sql query in HTML and format the results into a table?

I haven't really got...

Works like a dream,

Thanks Lynn

It is fairly simple to do - you need to create an "ON UPDATE" trigger on your table (a) that pulls the data you want to send into either a...

Thanks that looks great - i'll give it a try later and let you know how it goes.

I need to have the date in that format to save in a Csv file that will be imported into sage later. Safe is being really funny about the formats...

I've been looking into this as well and unfortunately this was not inluded in the Express edition, you will need to upgrade to full SQL i'm afraid.

The way i got...

I've been looking into this as well and unfortunately this was not inluded in the Express edition, you will need to upgrade to full SQL i'm afraid.

The way i got...

I do have another question along the same line... i need to add a where condition to my trigger but get the error below:

Msg 156, Level 15, State 1,...

Once Again SQL Server Central comes out on top!!

Thanks for your help!

Ian Scarlett (8/11/2009)

---

As you didn't post any schema details, I couldn't test the first part of your script. The SET statements should be SELECT statements. Try this.

DECLARE @CALL int

SELECT @CALL...