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

    February 21, 2006 at 10:22 am

    #622371

  • 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!

    December 7, 2005 at 3:17 pm

    #608284

  • RE: Update Table by Replacing NULLS

    Thanks a lot Farell, worked me great!

    October 13, 2005 at 11:00 am

    #597169

  • RE: Problem with Datetime format

    Senthil! try this.

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

    October 10, 2005 at 11:47 am

    #596347

  • RE: TOP Operator using a local variable

    The nat_BusinessCalendar table looks like this as you know.

    BDate                                                BUSINESS_DAY

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

    October 3, 2005 at 3:20 pm

    #594686

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

    October 3, 2005 at 2:49 pm

    #594677

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

    September 29, 2005 at 9:18 am

    #594070

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

    September 29, 2005 at 8:27 am

    #594052

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

    September 28, 2005 at 9:32 am

    #593718

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

    September 27, 2005 at 10:21 am

    #593355

  • RE: TOP Operator using a local variable

    Thanks Remi, u rock as usual.

    September 27, 2005 at 9:58 am

    #593346

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

    September 27, 2005 at 8:49 am

    #593299

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

    September 26, 2005 at 3:19 pm

    #593139

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

    September 21, 2005 at 12:15 pm

    #591949

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