Envelope-free to deposit checks in ATM

Wachovia Bank now can deposit your check without envelopes. You do not have to even put the amount y0u are going to deposit. The ATM machine can read and scan checks and automatically know how much money that will be. You can deposit multiple checks at one time. It is very convenient. Then if you want a receipt, you did have a choice to get a receipt with scanned check images.

Not sure if the ATM machines in other banks have the same kind of features, I do find this new feature is very useful to customers.

Link to Wachovia bank

GIS Map templates

Would like to create a professional map, or create a map like ESRI sample map viewer, please go to the webpage to download the sample map documents.

http://resources.esri.com/maptemplates/index.cfm?fa=codeGallery

All you need to do is to change the data source and/or the coordinate system (projection).

calling a stored procedure from asp.net

If you would like to use the asp.net code to call a stored procedure from SQL, the following article will show you how to do it step-by-step.

http://www.macronimous.com/resources/calling_stored_procedures_from_ASP.NET_and_VB.NET.asp

SQL insert,

If you like to insert value in SQL table based on a selected data set from another table, you can use the following syntax:

Insert into table1 (Col1, Col2, col3)
select Col1, Col2, col3 from table2 where Col1 > 'abcde'

Ipad

read a lot of Ipad news about apple, very impressive product.

I think the following features would make it more popular.

1. Video Camera
2. GPS navigation system
3. A built-in Free drawing application, maybe there is one, but I do not know.

For multi-tasking, I do not care that much. As long as it works quickly and smoothly for each application, it is enough.

KitchenAid Pasta Roller to make Dumpling Skin

I found out a quick way to use the KitchenAid KPRA Pasta Roller Attachment for Stand Mixers to make the Jiaozi (dumpling) skin. First, use the standard mixer to make the dough. Then take the dough out and cut a big piece of dough to roll the dough into a long soft stick shape by hand. Then cut the dough by small pieces. each small piece will be made to one dumpling skin.

Then using Pasta Roller to roll the small pieces by using the thickness grade of 2, the small piece will be into an oval shape. Then adjust the thickness grade into 3 or 4, then roll the same small dough piece by the other side, the dough will be rolled into a circle (round) shape. It is very simple and easy. You can adjust the thickness grade of the roller to make the dumpling skin bigger or smaller.

Enjoy your dumpling.

common table expression (CTE) in SQL

Have you ever used the Common Table Expression in SQL query scripts? It is very useful feature. CTE make the scripts easier to read and maintain. And it is also easier to write sql scripts with CTE for complex queries. CTEs can reference themselves.

With CTE_Table as
(
select column1, column2, column3 ... from table1 join table2 on column1 = column3
)

select *, table3.column1 from CTE_Table join Table3 on .........................


The script is very clean and simple