| Author |
Topic |
|
Kristen
Test
22859 Posts |
 Posted - 2006-08-09 : 13:53:03
|
I'm jealous of Madhi's threads ...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47264711 replies and 28,178 readshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926141 replies and 33,262 readsHow the hell can exporting to Excel generate 141 replies?  Surely people aren't exporting SQL data to Excel to use it as a relational database? There are half a dozen FollowUp threads linked to Articles which have scored more reads, but probably because they are easier fodder for Search Engine SpidersOther than those I reckon Madhi is the Top Threader!Kristen |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-09 : 13:59:09
|
you wouldn't believe how much traffic exporting to excel gets...i get around 150 views per day for this one: http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspxand it's been up only 2 weeks. to me that seems a lot... so yeah.. it's possible  seems export to excel is one big demand to management.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-09 : 22:33:55
|
quote:
Originally posted by spirit1...seems export to excel is one big demand to management...
People always seem to want their data in Excel.I have a server that is basically dedicated to running DTS jobs to create Excel files, hundreds each day. Everything from simple data dumps to elaborate worksheets with hundreds of tabs, graphs, pivot tables, fancy formatting, etc.My theory is that the dumbest people demand the most elaborate spreadsheets. They know they’re dumb, so they want fancy spreadsheets to make it look like they’re performing elaborate analysis. The reality is that that most have no more use for the information that they demand than a rock would.CODO ERGO SUM |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-09 : 23:02:38
|
quote:
Originally posted by Kristen
I'm jealous of Madhi's threads ...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47264711 replies and 28,178 readshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926141 replies and 33,262 readsHow the hell can exporting to Excel generate 141 replies? Surely people aren't exporting SQL data to Excel to use it as a relational database? There are half a dozen FollowUp threads linked to Articles which have scored more reads, but probably because they are easier fodder for Search Engine SpidersOther than those I reckon Madhi is the Top Threader!Kristen
Maybe the title for Excel thread, "Export to Excel", is a really good match for the way people search on google. I did a google search for "Export to Excel", and that thread came up as number 7.I have been a little surprised at which threads that I posted in the Script Library have the most views. I have posted 18 threads there, and 5 have more than 1000 views:UNIX Time Conversion Functions, 1175 viewsNumber Table Function, 2370 viewsDate Table Function F_TABLE_DATE, 3000 viewsDate/Time Info and Script Links, 3001 viewsStart of Week Function, 9284 viewsI did a google search for "Start of Week", and that thread was number 10. Maybe a name that is a good match for the way people do searches is the key to a lot of views, because how many people really need a Start of Week Function?CODO ERGO SUM |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-08-10 : 00:59:46
|
| Put 'start of week SQL' and you are number one and so are Madhi with 'export excel sql', so SQL makes (again) all the difference -- The Heisenberg uncertainty principle also applies when debugging |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-10 : 12:08:19
|
Kristen, your FAQ and Kristen's List threads are chasing my threads  MadhivananFailing to plan is Planning to fail |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-10 : 12:22:32
|
| Just discovered that a lot of the reporting at one of my companies is going to migrate from business objects to excel.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-10 : 12:34:41
|
| one of your companies, nigel?How many do you own? Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
Madhi tops 33k