you don't need the SELECT next to the GETDATE() , remove that and it should work.

you could write a trigger, but a better way would be to deny delete permissions for your users.

if you have parameters and have deployed the reports previously. Then any changes you make to the parameters such as default values etc.. will not be over-written. Maybe...

rather than put more work on the tempDb, you could create them a dedicated Staging Database and put this in simple mode so that log backups are not needed.

You may be able to use MS Lync for this, host a never ending online meeting on the big screen and people can join in and share their...

yes it is possible, as long as it is part of a transaction

If you get onto the sql server and look at the management logs there will be an error message with a severity and sate number, this will give you the...

I would prefer to have NULLS rather than '' as it is obvious that the value is blank.

do you mean tables and data from user defined databases?

if so, then there is no chance without having the backups specifically for those databases, the master database does not hold...

what is the value for ReportItems!Textbox45.Value for the error rows?

It could possibly be a null/empty so would not match your IF condition and will then cause a divide by zero...

I agree, there is no reason to deride a person for writing bad code. Saying something that refers to the person being an idiot or saying you want to...

As a consultant I have learned not to crtitise any legacy code that I see (new code from someone in my team is a different story) as quite often...

dave.chapman (11/10/2011)

---

Along those same lines, I want to back up or copy table and data to restore on a different server in a different database. Any good suggestions here?...

you could do this with a cte and row_number() or an inner join

eg.

to select the rows with duplicates and get the maxdate created, if you want to include non-duplicates...

have a look at the MAP toolkit, it should give you 1,2 not sure about 3 though.

http://technet.microsoft.com/en-us/library/bb977556.aspx%5B/url%5D