SEDAN DRIVERS FOR MAJOR EVENTS NEEDED!

WHYUBER

Is looking for new drivers in your area.
You can set your own hours and make up to $150 a day if

You are…
At least 21 years old, with a driver’s license and auto insurance.

Your Vehicle Is. . .
Any mid-size or full-size 4-door vehicle 2005 or newer in excellent condition.
Earn a $100 bonus if after completing number of rides (usually 10-20)

You have a smart phone, and can work late nights.

http://WhyUBER.com

SQL – INNER vs Left

Select sah.*,ari.*
From prddtalib.slsah sah
Inner join prddtalib.arari ari on ari.UCIHACTID = sah.actid
left join prddtalib.slsad sad on sad.actid=ari.UCITACTID
Where sad.sahnum is null

vs

SELECT * FROM devdtalib/slsah, devdtalib/arari WHERE SLSAH.ACTID =
ARARI.UCIHACTID and NOT EXISTs( SELECT SLSAD.ACTID FROM
DEVDTALIB/SLSAD where ARARI.UCITACTID = SLSAD.ACTID)

Adding New User to LANSA SQL Database LANSADB

Because we have migrated to a new network profile, our access to our LANSA SQL database will now be denied.  These instructions can also be used if inheriting someone’s LANSA install and would like to continue using their existing environment.

 

You need SQL Management studio to add a new login user to SQL, if  not installed you can down load it from Microsoft’s Download center.

 

http://www.microsoft.com/en-us/download/details.aspx?id=7593

 

To add a new user to your SQL database

SQL SERVER 2008

Number 3 Microsoft® SQL Server® 2008 Management Studio Express
ugly2

Install using your pc name/ SQLSERVER as server name
ugly3

Right Click LOGINS and select New
ugly4

This is the ADD screen, use my credentials as a guide.
ugly5

ugly6

ugly7

ugly8

SQL SERVER 2008

 

 

Sterling Silver Small Currituck Beach Lighthouse Charm

Sterling-Silver-Small-Currituck-Beach-Lighthouse-Charm
Currituck Lighthouse was built in 1875 and is 162 feet tall. It took one and a half years to build and cost around $178,000 to construct. It was the last of four beacons placed at intervals from Cape Henry, Virginia to Cape Hatteras. It is located thirty-four miles south of Cape Henry Lighthouse and thirty-two and a half miles north-northwest of Bodie Island Lighthouse. This Charm was hand designed with great detail by Linc Mason. It has a hollow back and is 1″tall.

JDE Events

Listing of ER for Application : Item Master Application (P594101)
=======================================================================
     FORM: Item Master Revision [FIX INSPECT] (W594101A)
=======================================================================
     CONTROL:  FORM
     EVENT:  Dialog is Initialized
———————————————————————–
0001 VA frm_szProgramId_PID = “P594101”
0002 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0003 //

———————————————————————–
     EVENT:  Clear Screen Before Add
———————————————————————–
0001 // Instrustor led assignment
0002 // This event point occurs when the form first appears

Default today’s date
0003 FC Effective Date = SL DateToday
0004 // as the effective date
0005 //

———————————————————————–
     EVENT:  Add Record to DB – Before
———————————————————————–
0001 // FIle IO Trigger occurs before the add record
0002 // Initialize audit fields
0003 BC Program ID (F594101) = VA frm_szProgramId_PID
0004 //

———————————————————————–
     EVENT:  Update Record to DB – Before
———————————————————————–
0001 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0002 BC Program ID (F594101) = VA frm_szProgramId_PID
0003 //

———————————————————————–
     EVENT:  Variables
———————————————————————–
     frm_szProgramId_PID

=======================================================================
     CONTROL:  EDIT Effective Date
     EVENT:  Control is Exited
———————————————————————–
0001 // If left blank default to today’s date.
0002 If FC Effective Date is equal to <Null Date>
0003    FC Effective Date = SL DateToday
0004 Else
0005 End If

=======================================================================
     FORM: Work With Item Master [FIND BROWSE] (W594101B)
=======================================================================
     CONTROL:  FORM
     EVENT:  Dialog is Initialized
———————————————————————–
0001 Hide Grid Column(FC Grid, GC WorkStn ID)
0002 // This is initially hiding audit columns in grid..
0003 Hide Grid Column(FC Grid, GC UserID)
0004 Hide Grid Column(FC Grid, GC Time ofDay)
0005 Hide Grid Column(FC Grid, GC DateUpdated)
0006 Hide Grid Column(FC Grid, GC ProgramID)

———————————————————————–
     EVENT:  Media Objects – Row def
———————————————————————–
0001 Media Object Structures(GT594101, <MedObj Setup>, <MedObj Setup>, <MedObj Setup>, GC ItemNumber)

=======================================================================
     CONTROL:  HYPITEM &Select
     EVENT:  Button Clicked
———————————————————————–
0001 Call( App:P594101 , Form: W594101A )
        GC ItemNumber -> FI mnItemNumber

=======================================================================
     CONTROL:  HYPITEM &Add
     EVENT:  Button Clicked
———————————————————————–
0001 Call( App:P594101 , Form: W594101A )
0002 //

=======================================================================
     CONTROL:  HYPITEM Cop&y
     EVENT:  Button Clicked
———————————————————————–
0001 Call( App:P594101 , Form: W594101A )
        GC ItemNumber -> FI mnItemNumber

=======================================================================
     CONTROL:  CHKBOX Show Audit
     EVENT:  Selection Changed
———————————————————————–
0001 // This is to show or hide audit fields , by using check box
0002 If FC Show Audit is equal to “1”
0003    Show Grid Column(FC Grid, GC ProgramID)
0004    Show Grid Column(FC Grid, GC DateUpdated)
0005    Show Grid Column(FC Grid, GC Time ofDay)
0006    Show Grid Column(FC Grid, GC UserID)
0007    Show Grid Column(FC Grid, GC WorkStn ID)
0008 Else
0009    Hide Grid Column(FC Grid, GC UserID)
0010    Hide Grid Column(FC Grid, GC WorkStn ID)
0011    Hide Grid Column(FC Grid, GC Time ofDay)
0012    Hide Grid Column(FC Grid, GC DateUpdated)
0013    Hide Grid Column(FC Grid, GC ProgramID)
0014 End If

=======================================================================
     FORM: Item Master Revisions Multiple [HEADERLESS DETAIL] (W594101C)
=======================================================================
     CONTROL:  FORM
     EVENT:  Dialog is Initialized
———————————————————————–
0001 // Initialize the program ID
0002 //
0003 VA frm_szProgramId_PID = “P594101”

———————————————————————–
     EVENT:  Variables
———————————————————————–
     frm_szProgramId_PID

=======================================================================
     CONTROL:  GRID Grid
     EVENT:  Add Grid Rec to DB – Before
———————————————————————–
0001 // Populate Audit Field when a record is updated
0002 //
0003 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0004 BC Program ID (F594101) = VA frm_szProgramId_PID
0005 //
0006 // Force grid fields into db fields because system tries to use fields from
0007 // header instead of grid.
0008 BC Item Number (F594101) = GC ItemNumber

———————————————————————–
     EVENT:  Update Grid Rec to DB-Before
———————————————————————–
0001 // Populate Audit Field when a record is added
0002 //
0003 Get Audit Information
        BC User ID (F594101) <- BF szUserName
        BC Date – Updated (F594101) <- BF jdDate
        BC Time of Day (F594101) <- BF mnTime
        BC Work Station ID (F594101) <- BF szWorkstation_UserId
0004 BC Program ID (F594101) = VA frm_szProgramId_PID
0005 //
0006 // Force grid fields into db fields because system tries to use fields from
0007 // header instead of grid.
0008 BC Item Number (F594101) = GC ItemNumber

———————————————————————–
     EVENT:  Row Exit & Changed – Asynch
———————————————————————–
0001 // Default to days date if left blank
0002 If GC EffectiveDate is equal to <Null Date>
0003    GC EffectiveDate = SL DateToday
0004 Else
0005 End If

Thursday January 03, 2013  15:32

What to Tip at Hotel

Not everyone agrees what guests should tip at hotels. Here’s what three etiquette and hospitality experts and three hotel companies suggest.

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Suggested tip by hotel guest

Etiquette expert Patricia Rossi:

Etiquette expert Jacqueline Whitmore:

Hospitality expert Roberta Nedry:

The Ritz-Carlton:

Hyatt Hotels:

Omni Hotels:

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Opening car door

$0

$0

$0

$0-$2

$0-$2

$0

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Parking car in valet lot

$0

$0-$3

$0

$0

$0-$2

$2

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Returning car from valet lot

$2-$5

$2-$5

$1

$2-$4

$1-$5

$2-$5

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Transporting bags from car to lobby

$1-$2/bag

$1-$2/bag

$1-$5

$0

$2-$5

$1/bag

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivering bags to guest room

$1-$2/bag

$1-$2/bag

$1/bag

$1/bag; $2/heavy bag

$1/bag or $5

$1-$2/bag

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Concierge

$0 for directions/restaurant recommendation; $3-$5 for show tickets/restaurant reservation; $15-$20 for sold-out-event tickets/premier restaurant reservation

$0 for directions/restaurant reservation; $10-$50 for hard-to-get event tickets/premier restaurant reservation

$0 for directions, information or simple reservations; $10 minimum for hard-to-get tickets/premier restaurant reservations

$0; $20-$30 for high-demand theater tickets/premier restaurant reservation

$0 for an answer to a simple question; $5-$10 for making dinner reservation and arranging transportation; $10-$50 daily for multiple bookings

$2/errand outside hotel; $1-$5/dinner reservation; $10-$20/reservation if recommended restaurant is outstanding; $5/event tickets; $10-$20/hard-to-get event tickets

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Maid

$3-$5/daily

$1-$2/twice daily

$1-$2/daily

$1/daily

$5 for one-night stay or $2/daily

$1-$5/daily

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Pool towel attendant

$1

$0; $1-$2 for special service

$0 unless special service is provided

$1-$2

$0

$1 if towel brought to you

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Spa personnel

15%-20%/service

15%-20% if not included in bill

15%-20%/service

$20/service*

15%-20%/service

10%-15%/service

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

One drink from bartender

$1

$1-$2 or 10%-15%

at least $1

$3-$4

15%-20%

$1

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

More than one drink from bartender

$1/drink

$1-$2/drink or 10%-15%

10%-20%

$5-$7

15%-20%

$1/drink; $5/round of drinks

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Waiter/waitress in restaurant

15%-20%

15%-20%

10%-20%

15%-20%

15%-20%

15%-20%

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Waiter/waitress at buffet meal

10%-15%

15%-20%

10%-15%

$5

15%-20%

10%-15%

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Wine steward

15%/wine bill

10%-20%/wine bill; $20-$30 if very expensive wine is ordered

10%-15%/wine bill

10%/wine bill

$0; tip on bill is sufficient

15%-20%/wine bill

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Servers during free food/drink at happy hour

$0 for food server; $1/drink

$0 unless tip jar is provided

$0 if guests get everything themselves

$0-$2

tip based on estimated retail value of free items received

$0

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Front-desk agent

$0; $3-$5 if give special service

$0

$0

$0 unless special service is provided

$0 unless concierge or bellman service is provided

$0 unless concierge service is provided

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivery of room-service order

$1 extra if 15%-18% tip is on bill; $18%-20% if no tip on bill

$0-$3 extra, plus tip on bill

$0, plus tip on bill, unless special service is provided

$2-$3 extra, plus tip on bill

$0, plus tip on bill

$0 unless very quick service is provided, plus tip on bill

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivery of extra towel, phone book or other requested item

$1/item

$1-$3

$0 unless hard-to-do item is requested

$0-$2

$0 unless special service is provided

$1

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Delivery of laundered/ironed clothing

$1-$3/item

$1-$3

$0; $5-$10 if require very quick turnaround

$2-$3

$0 unless special service is provided

$1

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

Repair person fixing a problem in room

$2-$5

$0

$0

$0-$5

$0 unless special service is provided

$0

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif

* = 10%-15% all-day service; $2 for robe/towel deliverySource: Etiquette and hospitality experts, hotels

Description: http://images.usatoday.com/_common/_images/ipr/grey.gif