Viewing 15 posts - 16 through 30 (of 86 total)
Thank you everyone for taking time to post, you have been most helpful!
I went with Chris's solution as I found it easier to read (at least for me anyway :P)
I...
October 27, 2010 at 7:51 am
Hi,
To calrify Work Day is Monday to Friday. Holidays are not material for the purpose of this report.
I would like to avoid the use of calender table if at all...
October 25, 2010 at 5:04 am
Hi and thanks for the info, unfortunately we are running SP3 so it had to be something else.
October 13, 2010 at 2:48 am
Hi thanks for all the feedback. Apologies for not replying to this post sooner (i really thought i had :P)
In the end we used ORIGINAL_LOGIN() and used the result in...
July 28, 2010 at 8:21 am
Thanks both for the code samples, it is greatly appreciated!
June 8, 2010 at 3:53 pm
Hi all,
I've been away on leave and have only recently had time to catch up.
Thanks for all the code samples you were extremely thorough :w00t:
March 15, 2010 at 7:03 am
Good article, especially since it shows both XP_CMDSHELL and the SQLCLR version.
I've never actually made use of SQLCLR but it looks like it may be the better solution for my...
March 15, 2010 at 6:40 am
Paul White (3/15/2010)
SSC Article: http://qa.sqlservercentral.com/articles/SQLCLR/65656/
Thanks, i'll give this one a read!
March 15, 2010 at 6:02 am
That could work ... thanks for the suggestion!
February 5, 2010 at 4:54 am
You can use the DatePart function to divide portions of the date but I don't believe you will be able to get the range from any built in function.
January 8, 2010 at 1:10 am
Cool thanks for the feedback, it's been bugging me for a while 😛
January 7, 2010 at 7:48 am
I maybe mistaken but I'm sure I read somewhere that TRUNCATE TABLE will be rejected if there is an FK pointing to the target table even if the FK table...
January 7, 2010 at 3:53 am
Great thanks for clearing that one up for me!
Sorry Dave, I see you had already indicated that in your first post. I need more coffee...
October 12, 2009 at 7:03 am
Bear with me for a sec.
The result of Value1/Value2 is 129200.84577771904321395533
What I would like is to fit this into a Decimal(18,17)
The following works:
CAST(Value1/Value2 AS DECIMAL(18,12))
But the following gives the...
October 12, 2009 at 6:50 am
I'm working on an old stored proc; the author of which I will not be able to get hold of.
I suppose I could reduce the precision but that could potentially...
October 12, 2009 at 5:59 am
Viewing 15 posts - 16 through 30 (of 86 total)