There is also another side to this: toleration of people that cheat. People that would never cheat themselves are often willing to overlook it in others. Is an...

Sadly, I am not longer shocked by this level of incompetence by a vendor. Actually, I have come to expect it.

Another big problem to watch is a mismatch between...

You do realize that the...

When you use the POWER function, you will get better results if you cast all the parameters to float. If needed, round the result.

select

MyNum,

CubeRootNumeric= power(1.0*MyNum,1.0/3),

CubeRootFloat= power(convert(float,MyNum),1E/3E)

from

(-- Test Data

selectMyNum =...

DBADave (8/21/2008)

---

That makes sense if I were comparing the two collations, but after running the ALTER TABLE...ALTER COLUMN all tables will be the default sort order/collation. Wouldn't comparisons at...

declare @x1 varchar(20), @x2 varchar(20)

select @x1 = 'a', @x2 = 'A'

if @x1 collate SQL_Latin1_General_CP850_BIN = @x2

print 'Equal 1' else print 'Not equal 1'

if @x1 collate SQL_Latin1_General_CP1_CI_AS = @x2

print 'Equal 2'...

Short? You guys need to try harder. :satisfied:

select

NewNum = right(1000000+MyNum,6)

from

( --Test Data

select MyNum=1union all

select 10union all

select 100union all

select 1000union all

select 10000union all

select 100000union all

select 999999 ) a

Results:

NewNum

------

000001

000010

000100

001000

010000

100000

999999

Access to the database can continue as normal.

Yes, you need to re-write the trigger completely to be able to handle multi-row updates.

Better yet, get rid of...

That really is a stupid question, but not very interesting.

As for the answer, you can just run the code yourself to get that.

greg (8/19/2008)

---

Thanks Avamin and Michael Valentine Jones for the quick reply...both of your answers are immensely helpful...

Just a few follow-on comments.

I initially had CompaniesID in the EarningsMiscWrk record, but then...

Add an additional unique constraint to the other tables with (tablenameID, CompanyID), then add CompanyId to table EarningsMiscWrk, and then create the FK references to be (tablenameID, CompanyID), instead of...

The F_UNIX_TIME_TO_DATETIME function on the link below will do what you want.

UNIX Time Conversion Functions

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66858

The code is simple, so you can also do it this way:

select

dateadd(ss,a.TIME_IN_SECONDS,25567)

from

MyTable a

If both columns are datetimes containing only dates (time part = 00:00:00.000), then this will do it.

where O.Delivery_Date-O.Date_Order_Placed >= convert(datetime,'19000102')

The only way to defragment a heap table is to create a clustered index.

You can create a clustered index and then drop it if there is some reason you don’t...