Viewing 15 posts - 76 through 90 (of 194 total)
NicHopper (4/9/2014)
Hi all,Thanks for your responses, since the lines in our case are to be the same length we achieved this without to much complexity.
Thank you all for your help.
Nic
If...
September 3, 2015 at 1:43 am
Alternatively he could use a Windows security group - if he is the only member of that group granting permissions to the group would effectively grant it to himself.
August 28, 2015 at 5:32 am
RonKyle (8/13/2015)
I don't understand what this means. Please clarify.
If you want to split the payment into installments - divide the total + any premium by the number of installments....
August 17, 2015 at 7:23 am
I tend to prefer working in the sub unit i.e. pence or cents rather than pounds, dollars or Euros. That way I can stick to integer arithmetic.
Where apportionment is required...
August 13, 2015 at 2:28 am
Jeff Moden (8/3/2015)
August 5, 2015 at 8:11 am
Jeff Moden (8/2/2015)
August 5, 2015 at 7:55 am
patrickmcginnis59 10839 (7/7/2015)
crmitchell (7/7/2015)
patrickmcginnis59 10839 (7/7/2015)
crmitchell (3/11/2013)
Matt Miller (#4) (3/8/2013)
July 7, 2015 at 8:32 am
patrickmcginnis59 10839 (7/7/2015)
crmitchell (3/11/2013)
Matt Miller (#4) (3/8/2013)
July 7, 2015 at 7:49 am
for a start
you have declared @Result as VARCHAR(MAX) so why are you converting to NVARCHAR(MAX) and so then forcing a further implicit conversion to VARCHAR(MAX)
I'd also suggest checking what the...
June 30, 2015 at 10:29 am
How about a Windows shutdown script which backs up the database to the USB drive then drops the database and a startup script to restore the database from the USB...
June 25, 2015 at 5:29 am
Jeff Moden (9/12/2010)
1. Hardware - Nill effect. Double the speed on the hardware on a 12 hour slug query and you still have a 6 hour slug query.
Are...
May 15, 2015 at 5:22 am
Jeff Moden (3/12/2015)
Heh... yeah... I love the ones with Dark Grey on a Black Background. Those are SO easy to read. :sick:
Almost as bad as very dark blue on...
March 13, 2015 at 5:28 am
Richard Warr (3/5/2015)
We had no way of telling if DELETE TABLE meant DELETE FROM or DROP TABLE. Both would have worked though 🙂
I had assumed that this was meaning DROP...
March 6, 2015 at 7:33 am
another caveat on no 6.
Check that you don't have any jobs which disable or worse delete and then later reenable or recreate those triggers.
If you do then they will break...
January 19, 2015 at 2:40 am
Viewing 15 posts - 76 through 90 (of 194 total)