Forum Replies Created

Viewing 15 posts - 61 through 75 (of 259 total)

  • RE: SUM Keeps decreasing when it should stay the same:

    --===== If the test table already exists, drop it

    IF OBJECT_ID('TempDB..#TeamSales','U') IS NOT NULL

    DROP TABLE #TeamSales

    --===== Create...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 11, 2008 at 9:31 am

    #801585

  • RE: SUM Keeps decreasing when it should stay the same:

    What would be the best way to get you some sample data?

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 10, 2008 at 3:08 pm

    #801204

  • RE: SUM Keeps decreasing when it should stay the same:

    For this particular COnsultant the amount should be the same because the AMount never changes regardless of the Achievelevel in which they are 60,70, and 80.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 10, 2008 at 1:53 pm

    #801174

  • RE: COUNT not working

    Thanks guys, I read about NULL and used your suggestion and it worked.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 10, 2008 at 12:47 pm

    #801147

  • RE: JOIN Not working right.

    I did a join to the temp table to see if that would get rid of the SubQuery issue but now I get duplicate records:

    SELECT v.ConsultantID

    ,SUM(PurchaseAmount) AS PORSalesTotal

    ,'PORSalesPoints'...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 8, 2008 at 2:05 pm

    #800000

  • RE: JOIN Not working right.

    With a little more input from BA I found myself going at this backward. In some cases I would be returning more than one row which leads to an issue...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 8, 2008 at 12:26 pm

    #799952

  • RE: JOIN Not working right.

    I see the the issue, the achievelevel changes so how can I go about suppressing the second row?

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 8, 2008 at 10:34 am

    #799891

  • RE: JOIN Not working right.

    I added the MIN as you suggested and it gives me a single record but none of the Case statements seem to work. I also tried it with MAX and...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 8, 2008 at 9:04 am

    #799824

  • RE: Convert Question

    The first one worked. THanks.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 3, 2008 at 2:21 pm

    #798084

  • RE: UPDATE using a HAVING

    That worked great. The final code was:

    UPDATE t

    SET points = points + 1

    FROM #Temp6 t

    INNER JOIN (SELECT ConsultantId

    ...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 3, 2008 at 12:29 pm

    #798011

  • RE: UPDATE using a HAVING

    Can you give me an example? That sort of confused me.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 3, 2008 at 8:40 am

    #797863

  • RE: OR is not working

    Any ideas on this?

    I have a question on the following code:

    Update #tConsultantPoints SET points = points + 1

    FROM #tConsultantPoints tCon

    INNER JOIN OtherTable ot ON ....

    where ot.month = @targetMonth AND...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 3, 2008 at 7:21 am

    #797786

  • RE: OR is not working

    I have a question on the following code:

    Update #tConsultantPoints SET points = points + 1

    FROM #tConsultantPoints tCon

    INNER JOIN OtherTable ot ON ....

    where ot.month = @targetMonth AND lifetimePORSales > 1000...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 2, 2008 at 2:15 pm

    #797504

  • RE: OR is not working

    It is run when ever a consultant wished to see the list. So it's will be pretty sporatic.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 2, 2008 at 10:38 am

    #797385

  • RE: HOw is the best way to build multiple filters?

    This work greats. The final code:

    DECLARE @BeginIssueDate Datetime

    DECLARE @EndIssueDate DateTime

    DECLARE @CertType VARCHAR(50)

    DECLARE @CertGRoup VARCHAR(50)

    DECLARE @CertStatus VARCHAR(50)

    DECLARE @StatusID int

    --Exec uspS_CertificateListing '01/01/2008','04/01/2008'

    SET @BeginIssueDate = '01/01/2008'

    SET @EndIssueDate ='04/01/2008'

    SET @CertType = 'Retail'

    SET @CertGroup =...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    April 1, 2008 at 8:30 pm

    #796977

Viewing 15 posts - 61 through 75 (of 259 total)