DefconDotNet

Untitled

Jan 27th, 2012
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var steps = _db.tblConversions.GroupBy(c => c.CvStep).OrderBy(c=>c.Key).Select(s => s.Key).ToList();
  2. foreach (var step in steps)
  3. {
  4.     var keywords =
  5.       _db.ExecuteQuery<string>(
  6.         "SELECT DISTINCT SkwKeyword FROM tblSearchKeywords WHERE  SkwIpAddress in (" +
  7.         " SELECT DISTINCT CvIP FROM tblConversions " +
  8.         " WHERE SkwIpAddress     IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep = {0}) " +
  9.         "  AND  SkwIpAddress NOT IN (SELECT DISTINCT CvIP FROM tblConversions WHERE CvStep > {0}))",
  10.         step);
  11.  
  12.     sb.AppendFormat("<tr><td>Stap&nbsp;{0}</td><td style=\"text-align:left;\">{1}</td></tr>",
  13.             step,
  14.             String.Join(" | ",keywords));
  15. }
Advertisement
Add Comment
Please, Sign In to add comment