Thank you very much Mark. So Simple Once you Know, Yet so Difficult.

Thanks again.

@mydays-1 works though @mydays is char type.  

ANSI is the way to go. but if you stick to ANSI standards you wont be able to use functions. Some of the additional features provided my MS SQL are...

AFAIK views cannot accept parameters. Instead you can either use a store procedure or a function which can accept parameters.

So what was the answer to this question? Hendry !!

how about this ?

update Mytable

set DateCol = Cast(datetime as varchar(11))

In http://www.tek-tips.com the orginator can mark accepted/usefull solutions (multiple) and based on that the points are awarded. They have Annual and Monthly Contests. Even in few other...

Try this out.

Create Procedure sp_test

@pTableNames varchar(200),

@pAction varchar(3)

as begin

DECLARE @npos Smallint

DECLARE @nStart Smallint

DECLARE @nFName...

Having a full time job and family to look after and still these guys are doing a great job. After all we do get support for fee.

Thanks to all...

Thanks !!! Having Triggers will slow down the Application. So i choose to fix duplicate records through a small delphi application and added constraints not to allow anymore duplicates.

Frank...

Yes !! Trigger can do the trick with some coding to check for duplicates.

Thanx jxflagg !!

Duplicate data is valid data and only the key is duplicated, so i cant delete the rows the only option is to change the key values in those records...

Thank you all for your time. Manual Intrevention is required which i was trying to avoid.

Thanks for the reply. I exactly planned to do the same. but i need to put the database offline to do this excercise and data we talking about 5 years...

I don't think you can create functions like SUM,Count with UDF.