Heh. I guess it depends how you define outsourcing Jeff. According to most employees that I...

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]...

Fourth line of the code, "Round(..)" function.

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

...

Hmm, you might want to move this to the SQL 2000 Administration forum.

Heh, are you slinging swine online again Jeff? :hehe:

As it happens, Brian Kelley posted an article on (2) just yesterday: http://www.sqlservercentral.com/articles/Security/65169/

bpowers (12/12/2008)

---

Ok thanks. Is there a way I can keep users from entering duplicate records now that identity is turned off? If I have two users in the form at...

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...

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...

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))

...

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...

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...

Try the one that I pointed you to. Let us know if you need anything that it does not provide.

Have...