Thanks, Jeff, for enlightening us. I do not know if I will encounter in a lifetime any of the issues you encounter every working day; your experience is of VLDB...

Why don't you make the field a PRIMARY KEY or set it as UNIQUE? Then SQLServer will validate automatically and reject a new insertion if its exists.

[Quote]I have 4 tables. Table1 contains user information, Table2 contains actual orders, Table3 contains future orders and Table4 contains all invoices that the user has accumulated. Table 2, Table3...

I am sorry, I should have indicated SUM instead of COUNT.

Use this:

[Code]SELECT COUNT(MyColumn) AS PosTotal FROM MyTable WHERE MyColumn >0 UNION ALL

SELECT COUNT(MyColumn) AS NegsTotal FROM MyTable WHERE MyColumn <0[/Code]

Thanks, will give it a shot.

Thanks, I am really grateful. I'd also appreciate some sample code for cross-platform triggers between MySQL and SQLServer2000.

I read about linked servers all the time here but have never qi\uite understood them, any primers out there?

Any help, friends?

In our culture, we have an opposite viewpoint which says that "A mountain is just sand if you get close enough!".

Thank you, Clifford, for your valuable contri. I just hope there are no malpractice lawyers snooping these forums to come after my employer using this post.

Your views are very valid,...

[Quote]RowID BeginDate EndDate Price ($)

1 01/01/2008 ...

The problem with SELECT DISTINCT is that it returns a distinct combination of all selected columns, so if you are just looking to return distinct based on the first column,...

Steve, thanks for shedding light. I had almost despaired.

Ours are small business apps where the client can give assorted rights (any combination) to their staff. We handle it on the...

Your problem is purely one of presentation. You may be able to use a cursor to build a single-string result-set, but then Jeff Moden will not be very pleased. What...