Join 3,438 readers in helping fund MetaFilter (Hide)

2 posts tagged with sql by apark.
Displaying 1 through 2 of 2.

Related tags:
+ (77)
+ (42)
+ (42)
+ (34)
+ (27)
+ (16)
+ (16)
+ (16)
+ (12)
+ (12)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (6)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)


Users that often use this tag:
desjardins (6)
DakotaPaul (6)
odinsdream (6)
iamkimiam (3)
arrowhead (3)
inigo2 (3)
mark7570 (2)
Anonymous (2)
jfricke (2)
dnash (2)
Four Flavors (2)
bleucube (2)
Wild_Eep (2)
Mrs. Pterodactyl (2)
apark (2)
maxwelton (2)
AllesKlar (2)
omnipotentq (2)
Just this guy, y'know (2)
benjh (2)
Glendale (2)
Jimbob (2)
Nothing (2)
Dr Dracator (2)
derbs (2)
adipocere (2)
eas98 (2)

How do to update rows without a cursor?

How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted by apark on Jan 24, 2007 - 5 answers

How to run a SQL Query on an Excel Spreadsheet

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers

Page: 1