# example: gawk -f sqlsplit.awk file-to-split.sql
BEGIN {
outfile = "erase_me.sql" #start off with a dummy file to get the ball rolling
IGNORECASE = 1
}
END {
#close off last file
print "grant "grant" on "arr[1]" to public\ngo\n" >>outfile
close(outfile)
}
/\/***** Object:/ {
#upon matcing the "object" comment, close off the previous output file
print "grant "grant" on "arr[1]" to public\ngo\n" >>outfile
close(outfile)
#start up the new one
match($0, /\[(.*)\]/, arr) #change to something like /\[dbo\]\.\[(.*)\]/ if you want “Schema qualify object names” enabled
outfile = arr[1]".sql"
print "--$Author:$\n--$Date:$\n--$Modtime:$\n--$History:$\n" > outfile
}
/^(create) +(proc|function|view)/ {
grant = "execute"
if ($2 == "view") grant = "select"
printf "if not exists(select 1 from sysobjects where name = '"arr[1]"')\n\texec('create "$2" "arr[1] >>outfile
# function is a little trickier because it could be a table or scalar return type requiring slightly different create function signature
if ($2 == "function") {
lines = ""
while((getline line) >0) {
lines = lines line"\n"
match(line, /returns/, a)
if (a[0] != "returns") { continue }
#debug: printf "line = %s, a[0] = %s, a[1] = %s, a[2] = %s, a[3] = %s\n", line, a[0], a[1], a[2], a[3]
match(line, /table/, a)
if (a[0] == "table") {
grant = "select"
print "() returns table as return select 1 as one')" >>outfile }
else print "() returns int begin return 0 end')" >>outfile
break
}
}
#proc/view
else {
print " as select 1 as one')" >>outfile
}
print "GO" >>outfile
sub(/create/, "alter") #change the create to alter
sub(/$/, lines) #tack back on the lines "eaten" to figure out whether function was tabular or scalar
}
{
print >>outfile
}
Popcorn Hour boxes - ($200 – $350)
One of the most popular right now… especially Euro/Asian markets… very much a kitchen sink of features
Patriot (memory company) - “Box Office” ($100)
Iomega – Sreenplay line (<$100 for Iomega ScreenPlay TV Link Director Edition w/o drive)
Seagate – FreeAgent Theater+, GoFlex TV ($120 range)
ASUS – O!Play Air (HDP-R3) (Best One Yet!?)
(Update: 5 Jan 2010) LaCie - LaCinema Rugged HD
(Update: 5 Jan 2010) Western Digital – WD TV Live (WDBAAN0000NBK)
Western Digital – WD TV (WDAVN00BN) 
Highlights:
Cirago (CMC1000) 
Highlights:
Here’s the main page for the receiver only products (so called “OEM”)
10x (BlueTooth) - this is the one Andrew and I have
I still wonder if USB might be slightly easier to deal with than waiting for BlueTooth to connect, especially if you’re primarily using in a static environment like a car and it avoids the rechargeable battery dance so here’s a couple of those…
20x (USB)
18x (USB)
