Viewing 15 posts - 1 through 15 (of 2,267 total)
you don't need the SELECT next to the GETDATE() , remove that and it should work.
August 5, 2013 at 10:20 am
you could write a trigger, but a better way would be to deny delete permissions for your users.
July 26, 2013 at 5:19 am
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...
July 26, 2013 at 5:12 am
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.
July 24, 2013 at 4:12 am
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...
July 10, 2013 at 8:15 am
yes it is possible, as long as it is part of a transaction
June 20, 2013 at 4:38 am
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...
January 10, 2013 at 3:37 pm
I would prefer to have NULLS rather than '' as it is obvious that the value is blank.
January 3, 2013 at 5:27 am
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...
November 28, 2012 at 4:56 am
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...
November 28, 2012 at 4:53 am
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...
November 14, 2011 at 4:18 pm
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...
November 11, 2011 at 1:46 pm
November 10, 2011 at 8:16 am
you could do this with a cte and row_number() or an inner join
to select the rows with duplicates and get the maxdate created, if you want to include non-duplicates...
November 9, 2011 at 10:16 am
have a look at the MAP toolkit, it should give you 1,2 not sure about 3 though.
November 9, 2011 at 8:50 am