Thanks rbrow112, I just could not remember yesterday. Know it was quit uneventfull. Thanks!

Can one make an assumption about the sequence

the statement d=@x,@x=@x+1 will be performed?

Always d=@d and then @x=@x+1?

An after thought read about convert in BOL 2000, you'll most likely going to need it again.

Crappy, keep on writing reports, explaining the problems, estimates, if not getting your heads of the sand scenario I have warned you, disk full, lost data, cost to resolve. How...

Linked Servers, DTS, BCP

Not good enough, specially in the case where multi updates participate in same transaction.

Seem to be working in simple, single updates.

Need some more grey stuff + time!

CREATE TRIGGER Test_Trig ON...

Some of the posters manage to keep the formatting, how do they post there text??

Have a look at

http://www.sqlservercentral.com/scripts/contributions/721.asp

Convert the datetime/ms to a string with CONVERT and return string to ADO back to app which can convert it back to the full monty of date/time/ms.

Not one update statement, hope it helps!

Create Table ItemBin (

Item varchar(80),

BinId varchar(10),

PutawayPriority int,

QtyMax numeric(19,2),

QtyOnHand numeric(19,2))

GO

Set NoCount On

Insert Into ItemBin Values ('A1', 'BIN1', 1, 100, 50)

Insert Into ItemBin Values ('A1', 'BIN2',...

These problems normally occurs when the 'date' is stored as a string / varchar and then compare with a date variable/value. If all the variables are datetime and you...

Agree with NPeeters suggestion!

BOL: BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.

Thus @date...

See Steve Jones example above, create an update trigger and the updated contents should be in the inserted table. Also look at the update(Col) function.

I think this may lead to some users picking up a phone and either complain about missing data or the error displayed or the funny rules that this field can...