You still can you Johnathan's method:

SELECT RIGHT(STUFF(CONVERT(char(26),GETDATE(),9),21,4,' '),11)

Minh Vu

I am very appreciate all of your help, special thank to Greg Larson. Reading your article helps me solve the problem. Again, my deepest gratitude.

Minh Vu

not at all.

Thanks very much.

However, it does not return correct record# position as my query return.

Ex. My query's result set like this:

1.A

2.B

3.d

4.f

when I used your statement, my result set become

4.a

3.b

2.f

1.d

How can I...

DTS in sqlserver can do the job for you.

Thanks for all of your helps.

Yes, I want one location can have multiple shipper, but only one will be a default at a time. Johnathan's trigger works...

I can not add [default] in the constrainst since it's a bit field. Also, I was asked to keep the current design. Therefore, I think of trigger, but...

Yes,that's what I've already checked, and I do have some records which do not end with '-tr', but they did appear in the past and my scrip did not return...

it just happened from yesterday. I suspect that the backup file got corrupt. In my errorlog file said:"Error while undoing logged operation in database 'Bill Master'. Error at log...

You can use this system UDF to read from your log file:

SELECT * FROM ::fn_dblog(1,NULL)

Hope this will help