how to do that - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how to do that

Author

Topic

Ali.M.Habib
Yak Posting Veteran

54 Posts

Posted - 2009-08-25 : 06:01:45

I have this table
CREATE TABLE [Test] (
[Branch] [binary] (3) NOT NULL ,
[Order_YYYYMMDD] [binary] (8) NOT NULL ,
[delivery_YYYYMMDD] [binary] (8) NOT NULL ,
[delivery_HHMMSSHS] [binary] (8) NOT NULL ,
[OrderNo] [binary] (8) NULL ,
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
(
[Branch]
[Order_YYYYMMDD],
[delivery_YYYYMMDD],
[delivery_HHMMSSHS]
) ON [PRIMARY]
) ON [PRIMARY]
GO

by mistake the user enter two orders to be delievered at the same day and the same time

for examle

[Branch] [Order_YYYYMMDD] [delivery_YYYYMMDD] [delivery_HHMMSSHS]

1 1/1/2009 1/5/2009 12:10:23
1 2/1/2009 1/5/2009 12:10:23

I want to update [delivery_HHMMSSHS] such that no repeated times per day

any help please

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-08-25 : 07:16:15

u want to delete the duplicate record
or update the duplicate record then with which value u want to update

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources