Thursday, November 29, 2012

APN setting for Iphone 5 running 6.0.1

To change your iPhone 5 APN setting 

1. Connect to WiFi
2. go to http://www.unlockit.co.nz
3. Select the 2nd icon from bottom "Create APN"
4. Select Country - USA, Carrier = AT&T MNVO (With Proxy)
5. Click Create APN
6. After downloading, it will ask to install.
7. Go ahead and install it.

Thats it.

Reference:
1. http://forums.macrumors.com/showpost.php?p=15813278&postcount=21


Friday, November 9, 2012

create table - test

-- temptable column FN, LN

insert into temptable (dsc.fn, dsc.ln, est.fn, etc.ln, dsc.id, ets.id)

select dsc.FN, DSC.LN, DCS.PersonID , ETS.FN, ETS.LN, ETS.PErsonID
 

from dsc, est

where ltrim(rtim(upper(replace(dsc.fn)))) = ltrim(rtim(upper(ets.fn)))
 

and ltrim(rtim(upper(replace(dsc.ln)))) = ltrim(rtim(upper(ets.ln)))
 

and ltrim(rtim(upper(replace(dsc.mn)))) = ltrim(rtim(upper(ets.mn)))
 

and dsc.dob = ets.dob
 

and ALL THE OTHER CONDITIONS