tsunami

log in
history

luke.breuer.com bcp searches

Luke Breuer
2008-12-21 23:28 UTC

counts are count(distinct client_ip)
  1. 07 google live yahoo bcp invalid descriptor index
  2. 05 google live yahoo Unable to open BCP host data-file
  3. 04 google live yahoo Invalid Descriptor Index bcp
  4. 04 google live yahoo bcp unexpected end of file
  5. 03 google live yahoo bcp Invalid character value for cast specification
  6. 03 google live yahoo invalid character value for cast specification bcp
  7. 03 google live yahoo I%2fO error while reading BCP format file
  8. 02 google live yahoo I%2FO error while reading bcp error-file.
  9. 02 google live yahoo SQL Server bcp Invalid Descriptor Index
  10. 02 google live yahoo unexpected EOF encountered in BCP data-file
  11. 02 google live yahoo I/O error while reading BCP format file
  12. 02 google live yahoo bcp "character type"
  13. 02 google live yahoo bcp format file delimiter
  14. 02 google live yahoo bcp right truncation
  15. 02 google live yahoo bcp format file delimiters
  16. 02 google live yahoo bcp "invalid character value for cast specification"
  17. 02 google live yahoo bcp column order
  18. 02 google live yahoo bcp error messages
  19. 02 google live yahoo bcp error string data right truncation
  20. 02 google live yahoo bcp field delimiter
  21. 01 google live yahoo bcp field delimiter tab
  22. 01 google live yahoo bcp file type mismatch error txt file
  23. 01 google live yahoo bcp file utilities read
  24. 01 google live yahoo BCP files fixed length vs delimited
  25. 01 google live yahoo bcp first few columns
  26. 01 google live yahoo bcp Fixed-length data fields
  27. 01 google live yahoo bcp for tables with different column order
  28. 01 google live yahoo bcp format file carriage return
  29. 01 google live yahoo bcp format file datetime
  30. 01 google live yahoo bcp error switch
  31. 01 google live yahoo BCP error unable to open format-file
  32. 01 google live yahoo bcp error while reading format file
  33. 01 google live yahoo bcp errors "unexpected end of file" error
  34. 01 google live yahoo bcp excel
  35. 01 google live yahoo bcp export adding extra delimited character at end of file
  36. 01 google live yahoo bcp export file switches
  37. 01 google live yahoo bcp export first row
  38. 01 google live yahoo bcp export fixed length no delimiter
  39. 01 google live yahoo bcp extra character first row
  40. 01 google live yahoo bcp column type
  41. 01 google live yahoo bcp column types
  42. 01 google live yahoo bcp columns only
  43. 01 google live yahoo bcp comma delimited remove new line
  44. 01 google live yahoo bcp data containing tabs
  45. 01 google live yahoo bcp data format switch
  46. 01 google live yahoo bcp data right truncation
  47. 01 google live yahoo BCP data upload
  48. 01 google live yahoo bcp data with embedded newlines
  49. 01 google live yahoo bcp datatype last field
  50. 01 google live yahoo bcp date column
  51. 01 google live yahoo bcp date format YYYY%2FMM%2FDD
  52. 01 google live yahoo bcp+datetime+format
  53. 01 google live yahoo bcp delimited character format
  54. 01 google live yahoo bcp embedded tabs
  55. 01 google live yahoo bcp eof
  56. 01 google live yahoo bcp error
  57. 01 google live yahoo bcp error "Invalid character value for cast specification"
  58. 01 google live yahoo bcp Error = %5BMicrosoft%5D%5BODBC SQL Server Driver%5DString data%2C right truncation
  59. 01 google live yahoo bcp error delimiter "%5Cn"
  60. 01 google live yahoo bcp error format
  61. 01 google live yahoo bcp error message format
  62. 01 google live yahoo BCP "Invalid Descriptor Index"
  63. 01 google live yahoo bcp + add extra field
  64. 01 google live yahoo bcp + data truncation
  65. 01 google live yahoo bcp + invalid time format
  66. 01 google live yahoo bcp + number of columns
  67. 01 google live yahoo bcp + row terminator + format file + bad record
  68. 01 google live yahoo BCP - C switch UNICODE ANSI
  69. 01 google live yahoo bcp issues in sql server 2005
  70. 01 google live yahoo bcp 9.0
  71. 01 google live yahoo bcp automatic upload files sql
  72. 01 google live yahoo bcp bad file descriptor
  73. 01 google live yahoo bcp bulk copy right truncation
  74. 01 google live yahoo bcp bulk copy syntax carriage return delimiter
  75. 01 google live yahoo bcp carriage return new line
  76. 01 google live yahoo BCP change source file column order
  77. 01 google live yahoo bcp characters in column%3f
  78. 01 google live yahoo bcp colid
  79. 01 google live yahoo "bcp column delimiter"
  80. 01 google live yahoo "bcp format file can't be opened"
  81. 01 google live yahoo "I%2FO error while reading BCP format file"
  82. 01 google live yahoo "Invalid character value for cast specification" datetime bcp
  83. 01 google live yahoo "invalid descriptor index" bcp
  84. 01 google live yahoo "sql server" bcp "right truncation"
  85. 01 google live yahoo "sql server" bcp with delimiter fields
  86. 01 google live yahoo "sql server 2000" bcp queryout incorrect rows copied
  87. 01 google live yahoo "Unable to open BCP host data-file" "format file"
  88. 01 google live yahoo "Unexpected EOF encountered in BCP data-file" -forum -forums -experts-exchange-com -newsgroup -newsgroups -sybase
  89. 01 google live yahoo %5cn in a column while bcp
  90. 01 google live yahoo (bcp EOF datetime)
  91. 01 google live yahoo +"end of file" +bcp
  92. 01 google live yahoo +bcp +"end of file"
  93. 01 google live yahoo 2 character delimiter in bcp
  94. 01 google live yahoo bcp%2C error in last record
  95. 01 google live yahoo BCP%2eexe missing rows
  96. 01 google live yahoo bcp%3A upload single column what is the delimiter
  97. 01 google live yahoo bcp%3A without delimiter uploading
  98. 01 google live yahoo bcp.exe "Invalid character value for cast specification"
  99. 01 google live yahoo bcp.exe bad file descriptor"
  100. 01 google live yahoo bcp.exe money truncation
SQL
You will have to view source to see the specifics, as tsunami is parsing code that generates code it parses...
with Term as (
    select  term = dbo.Extract_Search_Term(referrer),
            escaped = replace(replace(dbo.Extract_Search_Term(referrer), '#', '%23'), ' ', '+'),
            client_ip
    from    v_IIS_Typical
    where   dbo.Extract_Search_Term(referrer) like '%bcp%'
)
select  top 100 
        replace(replace(replace(replace(replace(
            '1. ?count ?google ?yahoo ?live  ?term'
            ,'?google', 'google')
            ,'?yahoo', 'live')
            ,'?live', 'yahoo')
            ,'?count', case when count(distinct client_ip) >= 100 then cast(count(distinct client_ip) as varchar) else '0' + cast(count(distinct client_ip) as varchar) end)
            ,'?term', term) 
from    Term
group by term, escaped
order by count(distinct client_ip) desc