INSERT INTO ProductSubjects (ID, ProductID, SubjectID)
SELECT NEWID(), '52EB01B6-B768-4F9B-8F60-1A695A13D945', Subjects.ID
Tuesday, March 31, 2009
This is just a simple example of doing an INSERT INTO one table from another, with a hard-coded value thrown into the mix.
Here I'm selecting the ID field followed by a concatenation of 3 different subject fields, depending on whether or not the fields are NULL.
WHEN Subject2 IS NULL THEN
WHEN Subject2 IS NOT NULL AND Subject3 IS NULL THEN
Subject1 + ' : ' + Subject2
ELSE Subject1 + ' : ' + Subject2 + ' : ' + Subject3
END AS TheSubject
ORDER BY TheSubject
Saturday, March 28, 2009
Here's how to create a report in Google Analytics that will give you an hourly traffic report for your site.
- Go to Custom Reporting
- Click "Creat new custom report"
- Open the "Site Usage" section on the left and drag Pageviews (or anything else you're looking for) over to one of the blue metric sections on the right
- Open the "Visitors" section on the left and drag "Hour of the day" to the green dimension section on the right
- Click edit next to the preset title and give your report a title if you want
- Click Create Report