Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: Date - List of Sundays

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

    Thanks again.

     

  • RE: Need help converting chars to a date result

     

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

  • RE: Comments on SELECT "AliasName" = ColName vs. AS

    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...

  • RE: can i pass a parameter to the view of SQLSERVER 2000

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

  • RE: Removing Time from Date

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

  • RE: Removing Time from Date

    how about this ?

    update Mytable

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

  • RE: Stars

    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...

  • RE: DYNAMIC SQL

    Try this out.

    Create Procedure sp_test

    @pTableNames varchar(200),

    @pAction varchar(3)

    as begin

    DECLARE @npos Smallint

    DECLARE @nStart Smallint

    DECLARE @nFName...

  • RE: QOD 12/17/03

    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...

  • RE: Unique Index

    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...

  • RE: Unique Index

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

    Thanx jxflagg !!

  • RE: Unique Index

    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...

  • RE: DB Maintenance Plan

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

  • RE: Indexed View

    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...

  • RE: My own aggregate function

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

Viewing 15 posts - 1 through 15 (of 19 total)