Forum Replies Created

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

  • RE: A Scary Comparison

    I agree that the document you linked is a bit misleading, if not downright lacking in information. It lists partial support for reporting services in the standard version, but does...

    March 27, 2008 at 7:25 am

    #794575

  • RE: Finding a sequence of rows that match another sequence of rows

    Mark (3/13/2008)

    Maybe this ?

    select r.SessionID

    from Requests r

    inner join PageFlow p on p.MatchValue=r.PageUrl

    group by r.SessionID

    having count(distinct r.PageUrl)=(select count(distinct MatchValue) from PageFlow)

    This seems like it would most definitely find the matching sessions,...

    March 13, 2008 at 8:05 am

    #789065

  • RE: Finding a sequence of rows that match another sequence of rows

    Here is the loop I referred to that is being used currently:

    set @Campaign = dbo.GetNextCampaign('');

    while @Campaign is not null begin

    set @GoalID = dbo.GetNextGoal(@Campaign, -1);

    while @GoalID is not null begin

    delete from...

    March 13, 2008 at 8:00 am

    #789055

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