Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: groupby/having not isolating duplicates

    Thank you for helping.  The filler order id field is one field and I do not think I need to extract the number.  In essence what I want is to...

    February 19, 2007 at 2:23 pm

    #690545

  • RE: group by/having not isolating duplicates

    Genius!  absolute Genius!

     

    Thank you!

    February 16, 2007 at 1:31 pm

    #690322

  • RE: group by/having not isolating duplicates

    When I use the format you suggested:

    Having count(*) >1

     

    I return no records when there are duplicates there. 

     

    Thank you.

    February 16, 2007 at 12:28 pm

    #690306

  • RE: wildcard date time format

    This is now my query:

     

    SELECT     Y.IDCode, X.CreatedWhen, X.OrderStatusCode, X.ReasonText,

                          X.Active, Y.BirthDayNum, Y.BirthMonthNum, Y.BirthYearNum, Y.DisplayName, Y.ApplicSource

    February 15, 2007 at 12:17 pm

    #690047

  • RE: wildcard date time format

    Select

     *

    from

     MyTable

    Where

     -- Greater than or equal to first day of month

     MyDateColumn >=  '20070101' and

     -- Less than first day of next month

     MyDateColumn <   '20070201'

     

    This worked, I knew my format was bad.

     

    Thanks. Would...

    February 15, 2007 at 10:28 am

    #690021

  • RE: wildcard date time format

    All,

     

    Using this same query,  I am trying to only pull duplicate records.  This is not working it does pull duplicates but everything else...

    February 15, 2007 at 9:41 am

    #690008

  • RE: wildcard date time format

    Thank you very much.  I used the (CONVERT(VARCHAR(10),X.CreatedWhen,112) LIKE '20070208')) and it worked like a charm.

     

    Thanks for being kind to a novice. You guys rock!

    February 14, 2007 at 1:55 pm

    #689833

Viewing 7 posts - 1 through 7 (of 7 total)