Posted in Excel Skills
on Dec 19th, 2010 | 0 comments
HSA = Health Savings Account
Since Excel 2000 Microsoft has been trying to dumb excel down (IMHO) to make spreadsheet work easier for more people. In doing so they try to have the program think for the user and help them do basic tasks. Most of the move in this direction took a giant leap forward in Excel 2007 and continues in Excel 2010. Side Note: I am please to have my “file” menu back in Excel 2010.
With Excel trying ability online to think for me, it would like to help me out and turn my HSA abbreviation into “has”. This is quite annoying when you really do not...
Posted in Binary, Financial Models
on Aug 26th, 2009 | 0 comments
Useful information if you have a linked server in MS SQL:
SELECT:
select * from openquery(’my_linked_server’, ’select * from table_schema.table_name’)
INSERT:
insert openquery(’my_linked_server, ’select column_1, column2 from table_schema.table_name’) values (’my_value1?, ‘my_value2?)
UPDATE:
update openquery(’my_linked_server, ’select column_1, column_2 from table_schema.table_name where pk = pk_value’) set column_1 = ‘my_value1?, column_2 = ‘my_value2? DELETE:
delete from openquery(’my_linked_server, ’select * from table_schema.table_name where pk =...