Viewing 15 posts - 1 through 15 (of 19 total)
Thank you very much Mark. So Simple Once you Know, Yet so Difficult.
Thanks again.
February 5, 2004 at 3:31 am
@mydays-1 works though @mydays is char type.
January 12, 2004 at 11:22 pm
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...
January 5, 2004 at 1:05 am
AFAIK views cannot accept parameters. Instead you can either use a store procedure or a function which can accept parameters.
January 5, 2004 at 12:49 am
So what was the answer to this question? Hendry !!
January 3, 2004 at 4:53 am
how about this ?
update Mytable
set DateCol = Cast(datetime as varchar(11))
December 29, 2003 at 11:57 pm
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...
December 29, 2003 at 6:35 am
Try this out.
Create Procedure sp_test
@pTableNames varchar(200),
@pAction varchar(3)
as begin
DECLARE @npos Smallint
DECLARE @nStart Smallint
DECLARE @nFName...
December 24, 2003 at 5:01 am
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...
December 17, 2003 at 3:19 am
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...
December 15, 2003 at 5:40 am
Yes !! Trigger can do the trick with some coding to check for duplicates.
Thanx jxflagg !!
December 14, 2003 at 12:40 am
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...
December 13, 2003 at 10:28 pm
Thank you all for your time. Manual Intrevention is required which i was trying to avoid.
December 11, 2003 at 12:59 am
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...
December 10, 2003 at 2:20 am
I don't think you can create functions like SUM,Count with UDF.
December 9, 2003 at 12:21 am
Viewing 15 posts - 1 through 15 (of 19 total)