Viewing 15 posts - 4,456 through 4,470 (of 7,631 total)
Jeff Moden (12/12/2008)
Outsourcing is absolutely the worst idea at all times...
Heh. I guess it depends how you define outsourcing Jeff. According to most employees that I...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 11:43 pm
The general rule that I hav efound for tags with arguments is that when they do not work you usually need to either add or remove quotes around the argument:
[highlight="#77ff11"]highlight[/highlight]...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 11:37 pm
Fourth line of the code, "Round(..)" function.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 11:22 pm
Here's a start:
Create Function ConvIn2Dec(@strIn As NVarchar(32)) Returns Numeric(18,9) As
Begin
Declare @ConvIn2Dec as Numeric(18,9)
--Set return value to 0
Select @ConvIn2Dec = 0
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 11:13 pm
Hmm, you might want to move this to the SQL 2000 Administration forum.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 9:30 pm
Heh, are you slinging swine online again Jeff? :hehe:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 9:25 pm
As it happens, Brian Kelley posted an article on (2) just yesterday: http://www.sqlservercentral.com/articles/Security/65169/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 6:28 pm
bpowers (12/12/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 6:05 pm
When the heck did fletching become obsolete?!? And here I spent the last twenty years honing my sons, one to be an expert fletcher and the other to be...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 5:31 pm
Just to echo what Jack was trying to convey: Why do your Identity/Key values have to be sequential with no gaps? There is rarely a reason good enough to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 4:56 pm
Try your ROLLUP results with the following changes to you source precisions:
Select
Case when
(AVG(CAST(cip.OriginalInvoiceAmount as MONEY)) = 0 ) then 0
else Round((1-(AVG(CAST(ci.udf_PaymentAmount as MONEY))
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 4:41 pm
This is neither unexpected nor necessarily incorrect. It is inevitable when calculating sums from fractional amounts that different accumulation orders and truncation points will result in small fractional differences...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 4:36 pm
To return it to a variable it would have to be in a separate query. To get results in the same dataset, you will either need to add extra...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 2:42 pm
Try the one that I pointed you to. Let us know if you need anything that it does not provide.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 2:34 pm
Jeff Moden (12/12/2008)
rbarryyoung (12/12/2008)
This should do it. You can use it either as a query or a View: http://www.sqlservercentral.com/scripts/tables/62545/Heh... dammit... now I'll never get the answer to my question...
Have...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 12, 2008 at 11:31 am
Viewing 15 posts - 4,456 through 4,470 (of 7,631 total)