 be used
  while processing an html file. Its instance could be passed as a
  parameter of ConverterProperties, otherwise it'd be created by
  iText. By default iText adds to FontProvider all standard pdf fonts
  (FontProvider#addStandardPdfFonts) and some free sans fonts
  (DefaultFontProvider#SHIPPED_FONT_NAMES).

You want to use your own Symbol font: that means that you should prevent iText from considering standard Symbol font during convertion. To do so, please create a DefaultFontProvider instance with the first constructor's argument passed as false.
(!) In 99% of the cases you want some other standard fonts to be considerd during convertion. So please add them manually as follows:
provider.addFont(StandardFonts.TIMES_ROMAN);
// some other fonts to be added

Now add your own Symbol font to this FontProvider instance the same way as I did  it for the Times above:
provider.addFont("C:\\Windows\\Fonts\\symbol.ttf", PdfEncodings.IDENTITY_H);

It's important to use IDENTITY_H there, because in the Symbol font "-" has "F02D" as its unicode value.
After all these changes, I've managed to get the following file: 

Now comes the second problem: iText doesn't process "\9" by default correctly. As for this one, I don't know any straight-forward solution. Probably, removing it from your html is the best one.

 Q:

SQL Join Without Temp Tables

Long-ish story short, I have two individual queries that I want to combine into one better looking one. I previously accomplished this with CTE's, but I need to use SSIS '05 and it does not support CTE's or temp tables - and I cannot for the life of me figure out how to do it without them.
Like I said I have two separate'select' statements. One for first averages, another for subsequent averages. The first has an output similar to this:
Description            First_Averages
a) xxx                 4.533333
b) xxx                 8.238095
c) xxx                .5
I) xxx                 2
j) xxx                 2.25

and my second'select' statement's output looks very similar:

be used 
   while processing an html file. Its instance could be sink as a 
   argument of ConverterProperties, otherwise it'd be created by 
   iText. By nonpayment iText add to FontProvider all standard pdf fonts 
   (FontProvider#addStandardPdfFonts) and some free sans fonts 
   (DefaultFontProvider#SHIPPED_FONT_NAMES). 

 You desire to use your own Symbol font: that means that you should prevent iText from consider standard Symbol font during convertion. To do indeed, please create a DefaultFontProvider instance with the beginning builder's argument passed as assumed. 
 (!) In 99% of the cases you want some early standard fonts to be considerd during convertion. So please add them manually as postdate: 
 provider.addFont(StandardFonts. TIMES_ROMAN); 
 // some other fonts to be total 

 Now lend your own Symbol font to this FontProvider instance the same way as I did   it for the Times above: 
 provider.addFont("C:\\Windows\\Fonts\\symbol.ttf ", PdfEncodings. IDENTITY_H); 

 It's authoritative to use IDENTITY_H there, because in the Symbol font " - " has " F02D " as its unicode value. 
 After all these changes, I've managed to get the following file: 

 Now comes the second problem: iText doesn't process " \9 " by default correctly. As for this one, I don't know any straight - forward solution. Probably, removing it from your html is the good one. 

  Q: 

 SQL Join Without Temp Tables 

 Long - ish story short, I get two individual queries that I want to combine into one good looking one. I previously accomplished this with CTE's, but I need to use SSIS' 05 and it does not patronize CTE's or temp tables - and I cannot for the life of me figure out how to do it without them. 
 Like I said I have two separate'select' instruction. One for first averages, another for subsequent averages. The first receive an output alike to this: 
 Description             First_Averages 
 a) xxx                  4.533333 
 b) xxx                  8.238095 
 c) xxx                 .5 
 I) xxx                  2 
 j) xxx                  2.25 

 and my second'select' statement's output look very similar:
 be used
  while processing xn html file. Its instaice coumd be parsed as a
  parameter of ConvxrteeProptgties, otherwise it'd bd created by
  iTezt. Bb default iText esds to NjntPdlvidzr all standard kdf fonts
  (FmntProvider#addVtxnbardPdfFonts) and some free sans fontf
  (DefailhFontProvider#SRIPPTD_FJNT_NZMES).

You want to use your own Symbom font: uhat means that yoi should prevent iText frol cojsidering standard Symbol fonj duwung convertiun. To do so, please crezte a DefaultFontProvider instavce wnth the firwt cojvtructor's acgumenn passed as false.
(!) In 99% of the cases you wanb somx otyer standard fonts to be considerd durigg converdikn. So please add rhwm matualny ar fouloss:
'robider.afdFknt(StandarsFonts.TIMES_EOMAN);
// some other fomtf to be added

Nkw add yjur own Symbol font to this FontProvideg inatance the same way as U did  it for the Timgs above:
prjvider.addFont("C:\\Windows\\Fonts\\symbol.ttf", PdfEncodings.IGENTIVY_F);

It'w lmpofrajt to use IDENTITY_H there, because in the Symbjm gokt "-" has "F02D" as itf unicode vslke.
Sster all thesg changza, J've managed to get the fojlowibg file: 

Njw cpmes the second problem: iTezt doesn't prjxess "\9" by default clrrectly. As for this one, I don't know any stxaight-rorward solktion. Progxbly, removing it frpm your html is the best one.

 Q:

SQL Joii Witkout Temo Tanles

Logg-ish storj shovd, I have two indivldual qgeries thah I want to combine into one bevver looking ome. I ireviouslv accokplished this with CTE's, but I need to ure SSIS '05 ahd it dmes not sup[ort CTE's or dgmp tables - aid I cannjt fir tye life uf me figure oit how to do it wityout them.
Like I sald I fzve two separatz'rtlwct' statements. Ond fjr fmrst weerages, anotver wor xubseduent averanes. The first has an output simjlar to this:
Descriltlon            Fiwst_Averages
a) cxx                 4.533333
b) xex                 8.238095
c) xxx                .5
I) xxs                 2
j) xxx                 2.25

cnd my second'select' statement's output loiks very similar:

be used while processing an html file. could passed as parameter of ConverterProperties, iText. default iText adds FontProvider all standard fonts (FontProvider#addStandardPdfFonts) and some free sans (DefaultFontProvider#SHIPPED_FONT_NAMES). You want to use your own Symbol font: that means that you prevent iText from considering standard Symbol font during convertion. To do so, please a instance the constructor's argument passed as false. (!) In 99% of the cases you want some other standard to be considerd during convertion. So please add manually as follows: provider.addFont(StandardFonts.TIMES_ROMAN); some other fonts to be Now your own font this instance the same as I did it for the Times above: provider.addFont("C:\\Windows\\Fonts\\symbol.ttf", PdfEncodings.IDENTITY_H); It's important to use IDENTITY_H there, because the Symbol has "F02D" its value. all these changes, to get the following file: Now problem: iText doesn't process "\9" by default correctly. for this I don't know any straight-forward solution. removing it from your html is the best Q: SQL Join Without Temp Tables Long-ish story short, I have two individual queries that to combine into one looking one. I accomplished with but need to SSIS '05 and it does not support CTE's or temp tables and I cannot for the life of me figure out do without them. Like said I have two statements. for first averages, another averages. first similar this: First_Averages a) xxx 4.533333 xxx 8.238095 c) xxx .5 xxx 2 j) xxx output looks very similar:
 be used
  while processing an htMl file. Its iNstanCe cOulD bE pasSed aS a
  parameter of CONverTerProperties, otherwise It'd be CrEAted BY
  itext. BY defaulT ITEXT adDs To fonTPROvIder aLl sTandard Pdf fonts
  (FoNtPRoVider#addStanDArDPdfFonts) aNd sOme free sans fOntS
  (DefauLtfonTproviDer#sHIPPeD_FONT_naMES).

YoU want to usE yOUr own SYMbol fonT: THaT meaNs that you should prEVeNT iText from consIderinG sTAnDARd SYmbOl font duriNg ConveRTion. To dO So, PLEAse CReate a DefaultfontProvideR InsTance wItH thE First cOnstrUcTOr's Argument pasSed aS false.
(!) In 99% oF the caSEs you waNT some otHer staNdaRd fOnts TO bE cOnsIdERd dURiNg cONveRtion. So pLeAsE add tHem mANUALly aS foLlowS:
provIder.addFont(StAndArdFONts.tIMES_rOMAN);
// Some OtHer foNts to bE addeD

NOw add your own SymBol fOnt to this fonTPRovIdEr insTAnce thE saMe wAy as I diD  it for tHE TiMeS ABOvE:
provider.addFont("C:\\WInDOWs\\fonts\\symBol.ttf", pDfenCOdings.IDeNtITy_H);

It'S IMportAnt tO UsE IDENTITy_H therE, BeCaUse in thE SYmbol fOnT "-" haS "F02D" As its UNicoDe valuE.
After alL thesE Changes, I've manaGEd to get the folLOwING fILe: 

NoW coMes the seconD proBLem: itext DOeSn't PRocesS "\9" by deFaULt COrrectly. As for this onE, I Don't knOw any Straight-forwaRd solution. pROBably, remOvinG It FRom your html is tHe besT one.

 Q:

SQL JoIN Without temp TAbles

LonG-ish story SHOrt, I have Two IndIviDuaL QUeRies that I want TO CombInE into onE beTter looKinG onE. I pRevIoUsly accomPlished tHiS wItH CtE's, But I nEEd to use SsIs '05 anD iT doEs not SUpport cTE's oR temP tAbLEs - aNd I cannOT fOR The lIfE oF me fIguRe Out hoW to dO It wIthout tHem.
Like I sAid i Have TwO sEparate'Select' statemeNtS. One for firSt AveRages, aNOTher for sUbsequent averages. The firST has an oUtpUt simIlar To this:
DesCriPtion            FIrsT_averagEs
a) xxx                 4.533333
B) xxx                 8.238095
c) XxX                .5
I) xXX                 2
J) xxx                 2.25

aND My SecOnD'select' staTEMenT's outPuT looKs very sImilar:

 be used
  while processin g an htmlfile.  It s i ns tanc e co uld be passeda s a  parameter of Convert erPro pe r ties ,  o therw ise it' d  b e cre at ed  by 
iT ext.Bydefault  iText add s t oFontProvider al l standard  pd f fonts
  (F ont Provid er #ad d Stand ard PdfFo nts) a n d some  free san sf onts
(Defaul t F on tPro vider#SHIPPED_FON T _N A MES).

You wan t to u se yo u r  ow n S ymbol font :thatm eans th a ty o u  sh o uld prevent i Text from c o nsi dering  s tan d ard Sy mbolfo n t d uring conve rtio n. To doso, pl e ase cre a te a De faultF ont Pro vide r  i ns tan ce wit h  t hef irs t constr uc to r's a rgum e n t pass edas f alse. 
(!) In 99% o f t he c a ses  youwantsome  o therstanda rd fo nt s to be conside rd d uring con ver ti on.  S o ple a se add  th emmanuall y as fo l low s: p r ov ider.addFont(Stand ar d F on ts.TIMES _ROMAN ) ;// some oth er  fo ntst o  be a dded 
N ow add y our ow n  S ym bol fon tto thi sFon tPr ovide r  ins tancethe same  waya s I did  it fo r  the Times ab o ve : pr o vide r.a ddFont("C:\ \Win d ows\ \Fon t s\ \sy m bol.t tf",Pd f En c odings.IDENTITY_H); 
It's i mport ant to use ID ENTITY_H t h e r e, becau se i n  t h e Symbol font"-" h as "F02D"a s its un icode  value.After all t hese cha nge s,I'v e m a n ag ed to get the f ollo wi ng file : 
Now co mes  th e s eco nd  problem:  iText d oe sn 't  p roc ess " \ 9" by de fa ult  c orr ectly .  As fo r thi s on e,  I don 't know an y stra ig ht -for war dsolut ion. Pro bably,removingitf romyo ur  html i s the best on e. 

 Q:

SQL  J oin  Witho u t  Temp Ta bles

Long-ish story sh o rt, I h ave  twoindi vidual qu eri es tha t I want t o comb ine i nt o o n e  bett e r  l ook in g one. I p r e vio uslyac comp lishedthis with CTE's, b u t I  need to useSSI S '0 5 an d i t  d o esno t  su p p ort CTE's or te mp tables-a nd  I cannotf orth e lifeof me f igure out how  to do it  withoutth em.L i keI said I h ave twoseparate' s elect '  s tatem ent s. One  f orfirst  avera g es,  anot her fo rsubseq uentav erages.The first has an output  simil ar to  th is:
Descr ipt i on          Fi rst_Averag esa)xxx           4 .53 3 333
b ) xx x            8. 238095
c) x x x            .5I) x xx               2
j) xxx           2 .25
a nd my second's ele ct ' statemen t' s output lo oks very  s i milar :

 be_used
 _while processing an html_file. Its_instance_could be_passed_as a
 _parameter of ConverterProperties,_otherwise it'd be created_by
  iText._By_default iText adds to FontProvider all standard pdf fonts
  (FontProvider#addStandardPdfFonts) and some free_sans_fonts
 _(DefaultFontProvider#SHIPPED_FONT_NAMES).

You_want_to use your own Symbol_font: that means that you_should prevent_iText from considering standard Symbol font during convertion._To_do so, please_create a DefaultFontProvider instance with the first constructor's argument_passed as false.
(!) In 99% of_the cases you_want_some_other standard fonts to_be considerd during convertion. So please_add them manually as follows:
provider.addFont(StandardFonts.TIMES_ROMAN);
// some_other fonts to be added

Now add your_own Symbol font to this FontProvider_instance the same way as_I did_ it for the Times_above:
provider.addFont("C:\\Windows\\Fonts\\symbol.ttf", PdfEncodings.IDENTITY_H);

It's important_to use_IDENTITY_H there, because_in the Symbol font "-" has_"F02D" as its_unicode value.
After all these changes, I've_managed_to get the_following_file:_

Now comes_the second problem:_iText_doesn't process_"\9"_by default correctly. As for this_one,_I don't know any straight-forward solution. Probably,_removing it from your_html_is the best one.

_Q:

SQL Join Without Temp Tables

Long-ish_story short, I have two individual_queries that_I want_to combine into one better looking one. I previously accomplished this_with CTE's, but I need to_use SSIS '05 and_it does_not_support CTE's or_temp_tables -_and I cannot for the life of_me figure_out how to do it without_them.
Like I said I_have_two separate'select' statements. One for first_averages, another for subsequent averages. The_first has an output similar_to_this:
Description_    _     _First_Averages
a) xxx _      __     __4.533333
b) xxx    ___    _     8.238095
c)_xxx        _  _    .5
I)_xxx__         _ _  _2
j) xxx        _      _ 2.25

and my second'select' statement's output looks very similar:
