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

Vegeterian: Similac ® Advance ® and Similac ® Advance ® Organic

About Similac® Advance® Organic Ready-to-Feed and Similac® Advance®.

I called their customer  care #: 1-800-850-7677 to ask if the Similac® Advance® contained any eggs derived ingredients or any  ingredient derived from animal blood or flesh.

The good news is none is derived. However, the Vitamin D is derived from Sheep Wool. The rep told me that sheep need not be slaughtered for this.

Test MI, NJ

-- Gets all table name and column name of MI which are not in NJ

SELECT mi.tablename,mi.ColumnName, mi.tablename || mi.ColumnName
FROM MI
where mi.tablename || mi.ColumnName NOT IN
(
SELECT  nj.tablename || nj.columnname
FROM  NJ)
;

-- -- Gets all table name and column name of NJ  which are not in MI

SELECT nj.tablename,nj.ColumnName, nj.tablename || nj.ColumnName
FROM NJ
where nj.tablename || nj.ColumnName NOT IN
(
SELECT  mi.tablename || mi.columnname
FROM  mi)
;
 

-- || is used for concatenation

test

 'abc_id' = Column name
'_id' =  string to be removed

select substr('abc_id', 0, length('abc_id') -  instr('abc_id', '_id') + 1 )  from table_name;

Flying clubs near to Lansing, MI

Flying Clubs

Olds Forge Flyers: P.O. Box 80565 Lansing, MI 48908-0565 (517) 351-4675
http://www.oldsforgeflyers.com/

Spartan Wings, Inc: 200 Shoesmith Rd Haslett, MI 48840 517-655-1432 http://www.spartanwings.com

15 Corporation: Mason
Darrell 517-282-5183
Share: 3500 + Monthly: 106/Month (may be $60 in near future) $60.00 wet
1970 Cesnna 177

Ledge Aero: Grand Ledge Airport. Address
President: Pwight: (W) 517.349.2096 (M) 517.281.0769

Member: John Oderink: 517-749-0926

Member (student): Ryan: 517.285.3800
Member: Kim : 517.230.9000

Flying Schools
Crosswinds Aviation (Cessna flying school)  : 3800 W. Grand River Howell, MI 48855 (517) 552-1101 http://flywithcrosswinds.com
 
GrandAir Aviation : 16815 Wright Road Grand Ledge, MI 48837 Phone: (517) 627-9557
http://grandairaviation.com

Instructors:
1. DAN HOLTZCLAW : http://danflite.com
2. Larry Benjaman: (H) 517.663.5870 (m) 517.204.4651

Hobbs Time or Tach Time?

Renting a plane for flying has different elements in it.

1. Wet/Dry: Wet means the fuel cost is included in the rental. Where as dry means one has to pay extra for the fuel above the normal rental rate. Of all the rates that I now I see are wet hours. But check with your club/instructor.

2.Hobbs Time or Tach Time: Putting is simple;

Hobbs Time: When the main engine starts Hobbs Time starts. So the time for taxi will about be counted towards rental.

Tach Time:When a aircraft reached a certain RPM, then the Tach Time starts.

So while renting Tach Time makes sense. But I guess on the other hand when logging time Hobbs time will "inflate" hours in the log book.

Total  concise definition (taken from the discussion forum stated below):

Tach Time: The tach is connected to the engine via a cable that turns with the engine and thus clocks at engine rotation speed. If you sit and idle long enough you will see that it is moving ever so slowly. It is designed to reflect a true hour at typical cruise RPM.

Hobbs Time: The Hobbs on the other hand is usually connected to an oil pressure switch that makes when the engine starts and records ,supposedly, a true hour.

A very good decision is here:

http://discussions.flightaware.com/general-aviation/hobbs-or-tach-t14059.html

Budget Rental car experience

Hello

This is regarding the rental car that I took last week. I wish to bring this to your notice that i do not wanted to the insurance since my auto insurance covers everything. But the sales rep on the counter scared me that I must buy insurance since it takes upto 9 months to get settled.

What basically she did was took advantage of my fear, and I was persuaded to take insurance. I understand I signed the papers which said I am buying insurance. But the point I want to make the "dirty" business tactics to make money. I do not know if she was getting any commission from this?

i except Budget being such a big rental company to see this and my guess is Budget does business which is genuine and based on honesty and not scaring customers.

If budget believe that the sales rep was pushing and not behaved in the best possible manner, I would like the have my insurance payments back.

Thanks very much
Ankit