I said "tariff and non-tariff-barriers to trade".

You said "this isn't a tariff. That's a tax."

This is a "non-tariff-barrier to trade" and just like tariffs, NTB are equally...

How far are we supposed to take this? You are talking specifically about the services in IT. Should we also require them to use computers that are made...

The .NET approach (or at least ASP.NET) is actually viable since this will be presented in a web page, but I kind of want other applications within my database server...

NPV: Net Present Value

IRR: Internal Rate of Return

They are explained in greater detail in the article at http://www.intelligententerprise.com/print_article_flat.jhtml?article=/online_only/celko/030303_1.jhtml

Regards,

Greg

I expect more from this website.

This is a relatively useless article and deserves to be pulled. The author makes three points:

1. Practice

2. Don't mention God

3. Curse

Only the first point...

Yeah, so I tried that system and compared it to a modified version of the modified script and the initial script is far better than either.

The method you described using...

I'll give that a try tomorrow, but with millions of records I have a hard time thinking that a function doing a couple hundred thousand clustered index scans in that...

Well, something like:

myMoney = 125.0000

set myCheck = select(myMoney - round(myMoney,0))

if myCheck != 0

begin

'something

end

Snigdha,

If everything that you have said is true then it seems you have a confusing table structure.

First post:

"The field TestRequestNo is a PK in TestRequest table and FK in Project...

Hi,

Thanks for the advice. I'm doing cursor processing (this is only on maybe 10,000 records per month and run once a month) and using OpenXML to get at the...

If the entire row is duplicate you can do:

select distinct * into tblVDN_BUCKET2 from tblVDN_BUCKET

drop table tblVDN_BUCKET

Be sure to drop/create keys/indexes/etc.

If you have another unique key field, or could add...

I couldn't agree more, Ray, but I'm not on the data collecting side of the application so I don't have much choice.

I looked in the books online for 2000 (what...

Hi,

Solved the problem with queries in the following syntax:

SELECT * FROM OPENROWSET ('MSDASQL','DSN=mySystemDSN','SELECT * FROM SCHEMA.TABLE')

Similarly I was able to create a linked server using the EM wizard and the...

Ok, that's interesting.

I'm using the RUMA AS/400 Optimized Server (32bit) driver version 2888.711.00.00

How does that compare with your version numbers?

Thanks!

Greg