Forum Replies Created

Viewing 7 posts - 31 through 37 (of 37 total)

  • RE: Distinct Row Query Help

    I'm not sure about the performance of this in a large scale, but I think I have the logic working.

    ;with RawData as

    (

    select 'DOC1' as DOC_NO, 'VER1' as REV_NO, 'PDF' as...

  • RE: Auto incrementing alphanumeric

    Do you need it as a function? Part of a stored procedure?

    Luis is spot on with the advice of maintaining separate columns for the Leter and the Counter. ...

  • RE: Auto incrementing alphanumeric

    Is the numeric sequence for Accounts and Contacts shared, or are they separate counters?

    For example, which set below is more appropriate:

    Set 1 - Separate counters

    A001234

    C005555

    C005556

    A001235

    Set 2 - Shared counter

    A001234

    C001235

    C001236

    A001237

  • RE: return count by individual days

    If you provide your table structure, some sample data and your expected results, I could help you better.

    See some guidance on providing this kind of thing here:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: return count by individual days

    Add JOIN_DATE to the Select list and a group by:

    select JOIN_DATE , count (*) from MEMBERS,dbo.MEMBER_PROFILE

    where MEMBER_PROFILE.member_no = members.member_no

    AND JOIN_DATE between '07-01-2013 00:01' and '07-31-2013 11:59'

    and email <>...

  • RE: SQL Pivot?

    Hi Ken -

    HOW variable is the data? I think this impacts the solution. Your example data currently results in 21 columns. What's the maximum # of rows...

  • RE: Memories of 2013

    My favorite SQL happening of the year is the job I've had since January, and how SQL Server and SSIS have enabled me to make an impact at my new...

Viewing 7 posts - 31 through 37 (of 37 total)