Posts

Code to fetch GROUPED delimiter separated records in SQL SERVER

Image
/* To return GROUPED delimiter separated records in OUTER QUERY which are already delimiter separated in INNER QUERY (SQL SERVER 2012) */ /* Table for Merchant Registration */ DECLARE @mer_registration TABLE ( mer_id INT ) INSERT INTO @mer_registration(mer_id) VALUES (1111111), (1212121) --SELECT * FROM @mer_registration /* Table for Merchant Sub Account  */ DECLARE @sub_account TABLE ( mer_id INT, sub_mer_id VARCHAR(50) ) INSERT INTO @sub_account(mer_id, sub_mer_id) VALUES (1111111,'sub_121'), (1111111,'sub_122'), (1111111,'sub_123'), (1111111,'sub_124'), (1111111,'sub_125'), (1111111,'sub_126'), (1111111,'sub_127'), (1212121,'sub_123'), (1212121,'sub_124') --SELECT * FROM @sub_account /* Table for merchant Report  */ DECLARE @account_report TABLE ( mer_id INT, sub_mer_id VARCHAR(50), report_type VARCHAR(10) ) INSERT INTO @account_...
Image
Find the Best Women's Hairstyle for Your Face Shape Melanie Pinola , Gawker Media Feb 5, 2015, 01.00 AM IST Women might have many more hairstyle options than men, but the same overall rules apply: It's best to pick the hairstyle that suits our faces the best. The images below should help you out. If you have a very round face, for example, short hairstyles and ponytails will likely only make your face look rounder. A more flattering style would be long layers and/or bangs. Here's the graphic posted on Visual.ly by Karen Ferreira : Not sure which shape your face is? The celeb photos below and tips from BeautySouthAfrica could help you identify yours: Anyway, once you know your face shape, you can choose more flattering haircuts. Which Haircut Suits Your Face Shape? | Visual.ly Credits : http://www.lifehacker.co.in/life/Find-the-Best-Womens-Hairstyle-for-Your-Face-Shape/articleshow/46126385.cms

14 Ways to Wrap Gifts with a Cloth

Image
Credits : http://www.lifehacker.co.in/others/14-Ways-to-Wrap-Gifts-with-a-Cloth/articleshow/45873803.cms   Heather Yamada Hosley , Gawker Media Jan 13, 2015, 08.30 PM IST Some gifts are just too oddly shaped for a traditional wrapping job. When wrapping paper just won't cut it, you can use a cloth to wrap just about anything. Traditionally used in Japan to carry items, you can use a furoshiki to wrap gifts of varying sizes-from bottles to balls. This method works especially well if you have a decorative cloth, like a scarf, that you want to give the person as well. To see the various ways to wrap different items, see the below chart. How to Use "Furoshiki" | Ministry of the Environment, Government of Japan via PopSugar

7 Incredibly Amazing Uses Of Your Phone Camera

Image
Clever Uses  Credits : http://www.lifehacker.co.in/jugaad/7-Incredibly-Amazing-Uses-Of-Your-Phone-Camera/articleshow/45783314.cms Nandini Sharma Jan 7, 2015, 11.25 AM IST Continuing with our 'Incredibly Amazing' series, here is some cool stuff that you can do with your phone camera. 1. When you are leaving a class or a meeting, always take a picture of the white board so that you know the notes or minutes. 2. Take a picture of all the business cards that you receive, so you don't have to collect heaps of them. 3. When you are packing for moving or for long vacations, click a picture of what's kept in which box or bag, so that you don't have to empty a whole lot for finding something which isn't even there. 4. Click a picture of your parking tickets, bill receipts, invoices so that you have all the details handy. 5. Instead of carrying your hard disk with you all the time, click a picture of its contents open on the computer screen to show...

10 Things You Never Knew Had Names

Image
Learning   Credits : http://www.lifehacker.co.in/jugaad/10-Things-You-Never-Knew-Had-Names/articleshow/45650443.cms   10 Things You Never Knew Had Names Nandini Sharma Dec 26, 2014, 04.59 PM IST Language is, no doubt, an amazing way to express what you feel. However, for some of us, this has been limited to some words that we use in daily lives. However, have you given a thought about things that seemingly have no name? Like, the smell of wet land after rain. But how can something not have a name, right? A few months back, we had given you this list of words you never knew existed . Now, taking ahead that list, given below are 10 things you probably didn't know had names. 1. Did you know that there is a name for the first cry of a newborn? It's called vagitus . 2. Did you know the name of the pea-sized dab you apply on your toothbrush? It's called nurdle . 3. Did you know that there is a name for the prongs on a fork? They are called tines . 4...

50 Delicious Cookie Recipes

Image
Credits : http://www.berries.com/blog/cookie-recipes?ref=ssssclprunkwn   October 31, 2014 We love cookies. You love cookies. So why would we only eat them for dessert? Hearty breakfast cookies. Delicate tea cakes. Chocolate-dipped cookies best served with an after-dinner coffee. There's a cookie for every meal of the day. We'll help you kick off your 24-hour cookie spree with 50 amazing recipes from our favorite food bloggers. 1. Dark Chocolate Pistachio Sea Salt Cookies Liberally infused with pistachios, crammed with chunks of dark chocolate and sprinkled with sea salt, Joy describes these slow bake cookies as “campfire meets fine dining.” We describe them as the perfect mix of sweet and salty. Thanks to Joy The Baker for sharing the photos and recipe for Dark Chocolate Pistachio Sea Salt Cookies . 2. Cinnamon Roll Sugar Cookies They may have started as sugar cookies, but a sprinkle...