Forum Replies Created

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

  • RE: Delete duplicate row

    The last 2 rows doesn't look like duplicates. still if you want to delete them, then just say

    delete from emp where empname = 'duptest4' or empname = 'duptest5'

    or use...

  • RE: sorting columns in a matrix group

    wow, I thought it's just impossible to sort a matrix group. It is working like a charm now. Thanks David!

  • RE: Update Table by Replacing NULLS

    Thanks a lot Farell, worked me great!

  • RE: Problem with Datetime format

    Senthil! try this.

    SELECT * FROM mytable WHERE convert(varchar(25),mydate,13) = convert(varchar(25),@mydate,13)

  • RE: TOP Operator using a local variable

    The nat_BusinessCalendar table looks like this as you know.

    BDate                                                BUSINESS_DAY

    --------------------------------------- ------------ ----------- ---

  • RE: TOP Operator using a local variable

    I don't think that I can make it a procedure as I need to use this function to update a date field in a table. I tried to make it a...

  • RE: TOP Operator using a local variable

    I am unable to use the SET ROWCOUNT with in a function Remi, getting this error.

    Server: Msg 443, Level 16, State 2, Procedure BUSINESS_DATEADD1, Line...

  • RE: TOP Operator using a local variable

    Hi Remi,

    is there any way that I can make this function work for negative intigers too?suppose if I say dbo.business_dateadd(getdate(), -3), then I should be able to get 09/26/05. Thanks for any...

  • RE: TOP Operator using a local variable

    Oh, I didn't turn up after. I got my function this way.

    CREATE FUNCTION DBO.BUSINESS_DATEADD (@STARTDATE DATETIME, @DAYS BIGINT )

    RETURNS DATETIME

    AS

    BEGIN

    DECLARE @ENDDATE DATETIME

    SET @ENDDATE = (SELECT DD FROM(SELECT T1.BDATE AS DD,...

  • RE: TOP Operator using a local variable

    no body else has a post count >6000 in SSC.com remi! and also by observing your pace and by seeing ur previous posts.

  • RE: TOP Operator using a local variable

    Thanks Remi, u rock as usual.

  • RE: TOP Operator using a local variable

    Hi Sushila,

     

    I was away from SSC.com for some time. When the time I'm back, I...

  • RE: TOP Operator using a local variable

    Hi Remi, Iam trying to create this function but Iam not sure that I can use the set rowcount here.

    CREATE FUNCTION DBO.BUSINESS_DATEADD (@STARTDATE DATETIME, @DAYS BIGINT )

    RETURNS DATETIME

    AS

    BEGIN

    DECLARE @ENDDATE DATETIME

    SET...

  • RE: Update table

    These are the tables I am working with

     

    CREATE TABLE [NAT_WORKORDER_DETAIL] (

    September 21, 2005 at 12:44 pm

    #591963

  • RE: Update table

    Ok, this is what I need to update

    update N_Order set N_Order.status = 2

    If N_Order.id = N_Inv.id and any one of the following is true

    (N_Inv.TF is not null...

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