Search Results

Search found 2 results on 1 pages for 'wefx'.

Page 1/1 | 1 

• How to re-add a missing font

  - by WEFX

  I recently upgraded from Office 2007 to 2010, and that went fairly smoothly. However, afterwards, my Calibri font was gone, so my Word and Outlook started using the next available font in the list... Comic Sans! I browsed to Control Panel Fonts, and saw that there was no longer a Calibri listing. I know that one way to recover a missing font is to just copy the missing font files from another computer. In my case, the four files I needed were: calibri.ttf, //regular calibrib.ttf, //bold calibrii.ttf, //italics calibriz.ttf, //bold and italics However, once I attempted to copy-and-paste these files to my computer, I realized these files were already on my problem computer; they never really got erased. I don't know why they aren't working in Office, and they aren't listed in Control Panel Fonts.

  Read the article

• Run a proc on several different values of one parameter

  - by WEFX

  I have the following query that gets run within a proc. The function MyFunction returns a table, and this query joins on that table. This proc works great when a @MyArg value is supplied. However, I’m wondering if there’s a way to run this on all @MyArg values in the database. I’m sure there’s a way to do it within a loop, but I know that loops are generally to be avoided at the db layer. I really just need to perform this for the sake of checking (and possibly cleansing) some bad data. SELECT ColumnA, ColumnB, ColumnC FROM ( SELECT a.ColumnA, a.ColumnB, a.ColumnC, ROW_NUMBER() over(partition by a.ColumnD order by f.ColumnX) as RowNum FROM dbo.MyTableA AS a INNER JOIN dbo.MyFunction(@MyArg) f ON f.myID = a.myID WHERE (a.myBit = 1 OR a.myID = @MyArg) ) AS x WHERE x.rownum = 1;

  Read the article

1