I know domain management for single domain name, but i cannot get it with multiple subdomain. When I select : What are you tracking?, i choose : One domain with multiple subdomains it finally give me the code with that : pageTracker._setDomainName(".notreaventure.com"); So on the domain xyz.com i made up a sub domain : aa.xyz.com and bb...
Hi Any ideas how i go about replacing the following self join using analytics SELECT t1.col1 col1, t1.col2 col2, SUM((extract(hour FROM (t1.times_stamp - t2.times_stamp)) * 3600 + extract(minute FROM ( t1.times_stamp - t2.times_stamp)) * 60 + extract(second FROM ( t1.times_stamp - t2.times_stamp)) ) ) div, COUNT(*) tot_count FROM tab1...
I'm refactoring a colleague's code, and I have several cases where he's using a cursor to get "the latest row that matches some predicate": His technique is to write the join as a cursor, order it by the date field descending, open the cursor, get the first row, and close the cursor. This requires calling a cursor for each row of the r...