Might just have to get a HP4

Hi all, I wonder if you can help me....

I have a CSV file that contains two sets of data, a SKU and an EAN and I want to update my database of SKU's with the EAN's.

My two tables are as follows.. and you can see that the table join is ProductID, its a 1 to many relationship.

table: Product
row: ProductID
row: SKU

table: ProductVariant
row: ProductID
row: EAN

This is as far as I have got and now I'm stuck on how to join the two table together in the query..

UPDATE ProductVariant SET EAN=ean.number
FROM
 OPENROWSET('Text;Database=C:\;',
 'SELECT * FROM [products.csv]')
where ???????

Many thanks for your help in advance.

The queens boat!?

#jubilee #queensdiamondjubilee #london2012

Guess what I'm doing tonight at +The Creative Sanctuary with +Angela Connor ?

Our first road trip abroad together.

My old K1200lt and my new K1300s

Finally starting to see some G+ integration (SPYW) on the UK search results?!?

#searchplusyourworld   #google   #googleplus   #googleplusupdate  

RESHARE:
This bloke is a LEGEND!

Reshared text:
Lmao at this guys interview about the 3 missing girls in Cleveland. A true American hero lol

God help me get out of this place as quickly as possible!

Our weekend walking up Ben Nevis near Fort William, staying in Inverness and driving the length of Loch Ness.

#scotland #bennevis #walking #mountains #inverness #lochness

There is the most amazing thunder storm going on over Hertford right now!

#weather #hertford #storms

No! Now I REALLY want one!!

#galaxys3 #samsunggalaxys3 #s3

20k! Considering how well they perform compared to the mens team I still think that this is a bit of an insult.

My old bike (K1200LT) and my new bike (K1300S).. if only I could have afforded both!

Looking to work with a dynamic, methodical and accurate developer for the upgrade of our store.

We use aspdotnetstorefront v9.1.0.1 and want to upgrade to v9.3.1 along with developing a mobile solution.

Our current store has quite a few core modifications but until we start to test the latest version we're undecided about moving them over.

Please PM if you are interested..

RESHARE:
Do you agree..?

Reshared text:
"So rock me momma like a wagon wheel
Rock me momma any way you feel"

This song has got everyone's feet on our office tapping this week... didn't know that he used to be the lead singer and rhythm guitarist of the 90's rock band Hootie & the Blowfish though!

Issue with xml.config file
I'm trying to drop some code in from Trusted Shops for their Buyer Protection but I'm getting an error back stating

Exception=Error in XmlPackage(.Load), Package=[page.orderconfirmation.xml.config], Msg=[Exception=The 'input' start tag on line 177 does not match the end tag of 'form'. Line 178, position 29.]

Here is the code..

<form id="formTShops" name="formTShops" method="post" action="https://www.trustedshops.com/shop/protection.php" target="_blank">
<input name="_charset_" type="hidden" value="">
<input name="shop_id" type="hidden" value="TS_SHOP-ID">
<input name="email" type="hidden" value="ord.EMail">
<input name="amount" type="hidden" value="ord.Total">
<input name="curr" type="hidden" value="GBP">
<input name="paymentType" type="hidden" value="ord.PaymentMethod">
<input name="kdnr" type="hidden" value="{value kdnr}">
<input name="ordernr" type="hidden" value="ord.OrderNumber">
We offer you the Trusted Shops Buyer Protection as an additional service. We cover all costs for this guarantee. All you have to do is register!
<br><br>
<input type="submit" id="btnProtect" name="btnProtect" value="Register for Trusted Shops Buyer Protection">
</form>

Any help would be greatly appreciated.

Date night!

UPS I love that you take such good care of my parcels!!

#UPS  

Used this website for the RAM mount on my K1300s that I fit my Sat-Nav to..

RESHARE:
Nice to see her up and about finally..

Reshared text:
Maria de Villota showed her cracked helmet yesterday...

#f1  

RESHARE:


Reshared text:
Making chains ... always wondered how they did it.

All that's left of our snowman in Hertford!

At a talk organised by my local dealer with St John Ambulance about first aid and what you should do if you are the first at the scene of an accident.

Got to love it when big sister tells on little sister then dad gets told off by grandma for trying to help!

Cruelty To Dogs
Really... would you be seen out with your dog wearing pants!!!

RESHARE:
Please re-share and show your support for UK made products..

Reshared text:
Made in Britain
We just love this article from Sundays (3rd February 2013) Times highlighting that manufacturing is coming back to the UK.

We're proud that our tube heater product has been made in the UK since 1948 (http://goo.gl/ClUpL) and we're always advocating buying British over lesser quality imports.  With Thermo Products you get next day delivery of your tubular heaters and guards, excellent customer service and a fast bespoke product if you require it.

RESHARE:


Reshared text:
Fall asleep on your belly? You could be hurting your health. Best positions for getting better sleep: http://on.wsj.com/XB1PRC

Just read this great quote... "If we constantly chose to think negative thoughts or consider the worst case, these thoughts will perpetuate. If we chose to consider positive thoughts, then the positive thought will become the new habit within our brain"

I think I'll be keeping my fingers crossed... Ananda

I wonder if +Robert Llewellyn had his doing this?

How funny is this Waitrose shop window advert!!

I just don't understand Google's thinking.. they are charging to list on Google Shopping then eBay is top of organics who are in effect a competitor?!!?

Absolutely crazy!

RESHARE:


Reshared text:
This is AMAZING!!! Watch to the very end. (via +Celeste Wolfe)

RESHARE:


Reshared text:

RESHARE:


Reshared text:
Nowadays, we are confronted by a huge gap between rich and poor. This is not only morally wrong, but practically a mistake. It leads to the rich living in anxiety and the poor living in frustration, which has the potential to lead to more violence. We have to work to reduce this gap. It’s truly unfair that some people should have so much while others go hungry.

Absolutely heartbreaking image from the Oklahoma tornado disaster earlier this week.

RESHARE:
With a face like that should really be riding a Harley!

Reshared text:
Gixxer Dog

I never knew that a model rc race track existed so close... Westmill Farm just of the A602 near Ware, Herts

RESHARE:
IMAX here I come!

Reshared text:
A new Star Trek trailer with a very different take on the action. I want to see this now more than ever. 

RESHARE:


Reshared text:
On this cold dreary Friday we've found this great Video that will surely put a smile on your face.. +1 or share if you agree!

Hilarious

At the MCN show.

Best Indian in Hertford!

RESHARE:


Reshared text:
Are you ready for another piece of The Truth About Love?!
Watch my new video for "Just Give Me A Reason" featuring Nate Ruess on +VEVO  - http://smarturl.it/JGMARVideo
Enjoy it! <3

RESHARE:
Yum Yum!

Reshared text:
34-metre Model Train Made Entirely From Chocolate ... Amusing Planet - "A 33.6-meter long train made entirely out of chocolate was unveiled at the Brussels Chocolate Week going on in Belgium. Constructed using 1,285 kg of the finest Belgian chocolate and packing an impressive 6.5million calories, the intricately detailed model was created by master chocolatier Andrew Farrugia from Malta. The model has entered the 'Guinness Book of Records' for the longest structure to be made entirely out of chocolate. ..." more yummy photos: http://www.amusingplanet.com/2012/11/34-metre-model-train-made-entirely-from.html #chocolate   #chocolatecravings   #railroad   #train  

Oh how I want one of these.

RESHARE:


Reshared text:

Repost if you are against bullying

SwiftKey 3 has saved me 10,000 keystrokes! Check it out at http://swiftkey.net

RESHARE:


Reshared text:
As the gruelling Dakar Rally begins, James Blake reports on a team of British war veterans competing.

When an innocent picture can go horribly wrong!

#fail   #funnypictures   #keepcalmandcarryon  

RESHARE:
I want a go!

Reshared text:
THE ROAD WARRIORS ♣Irish✜Road Racing . . and_'Southern 100' Isle of Man TT.

Smirk.. Date night..

Feelin' great.

Awesome!

RESHARE:


Reshared text:
Apparently money doesn't buy happiness — these stories will have you thankful you haven't won $500 million #powerball jackpot.

RESHARE:


Reshared text:
They've got all the guns, girls and gadgets as the rest of the movie, condensed into one handy, adrenalin-charged package. Here's every James Bond opening sequence, from worst to best: http://ti.me/YY2WwB

(Photo: Eon Productions)

RESHARE:
WTF!

Reshared text:
9 min video on qi :) ☺☻ power from History Channel. See the NatGeo video: Fight Science - Qi Gong Tested & 2min video on ♥ loving ♥ qi dissolving tumor instantly: goo.gl/gq1q1, qi sci paper: goo.gl/PbgOk, 10 min video on fire by qi: goo.gl/shsPP. As solar cars use sun qi, humans can feed/attain Immortality:) thru qi. See the 26 videos on eating qi :) (no food) for 1-65 yrs:  Living people:
1  Henri Monfort - A Breatharian Shaman (PL)
2  Master Liao Fong-Sheng - A Qigong Breatharian (PL)
3  Zinaida Baranova - More Than a Decade of Living on Prana [PL] (12+ years)
4  Akahi - A Breatharian from Ecuador (PL)
5  Breatharian couple, parents of a breatharian child - Akahi & Camila
6  Reine-Claire Lussier - Prana For a Busy Lifestyle (PL)
7 Dr Christopher Schneider - A Breatharian Scientist (PL)
8 Nun Shi Hongqing of China - Breatharian for Over 20 Years (PL)  (20+ years)
9  Living Food-Free - Oleg Maslov, Russian Artist & Teacher of Conscious Breathing [PL] 
10 Elitom Ben Yisrael - Challenges in Transitioning to Breatharianism (PL) 11 Victor Truviano - A Breatharian from Argentina (PL) 
12 Isabelle Hercelin - Breatharianism as a Way of Life (PL) 
13 Camila Castillos - A Breatharian Artist and Dancer (PL) 
14 Jasmuheen - The Amazing Avatar of Pranic Living [PL] 
15 Prahlad Jani - A Breatharian Holy Man (PL) (65+ years)
16 Oberom C. Silva - Returning to Our Divine Self through Breatharianism (PL) (11+ years)
17 Dr Mony Vital - A Lifestyle of True Freedom (PL) 
18 Anne-Dominique Bindschedler - Balance through a Pranarian Lifestyle (without part 2) [PL] 
19 Phan Tan Loc - A Waterian Farmer (PL) (tea for 14 years)

Former people who lived without food:
1 Louise Lateau - A 19th Century Waterian (PL)
2 Master Fu Hui - A Waterian Nun (PL)
3 Blessed Anne Catherine Emmerich - A 19th Century Breatharian Nun (PL) (12 years)
4 Maria Furtner - The Water Drinker from Frasdorf (PL) (52 years)
5 Blessed Helen of Enselmini and Elizabeth the Good - Breatharians through Noble Ideals (PL) 
6 Saint Mary Ann de Paredes - The Lily of Quito (PL) 
7 Mary J. Fancher - The Brooklyn Enigma (PL) 

  qi=energy or qi=mc2.  qi is named 'divine light' too by others.

Quote of the day
"God said 'Ask and you shall receive', he didn't say 'Bitch and whine and you shall receive." - Tony Robbins

Quote of the day
"The reason most people never reach their goals is that they don't define them, or ever seriously consider them as believable or achievable. Winners can tell you where they are going, what they plan to do along the way, and who will be sharing the adventure with them."  - Denis Waitley

#london2012  

RESHARE:
How very true

Reshared text:
How much is your time worth?

Waiting for the Olympic Torch to arrive in Hertford

RESHARE:
OMG!

Reshared text:
Heatwave Experiment #42: Dashboard cookies. We placed a sheet of cookies in a ThinkGeeker car at 11am today. After 5 hours in temperatures exceeding 157.5 degrees F (the thermometer crapped out), they came out crispy and slightly risen. Verdict: Tasty and scary. Current temperature: 99 degrees F.

Now this is COMMITMENT!

Chilli hot chocolate WOW!

Old School
Just found my old Pentax ME Super with lenses, flash and film that expired in 1998!

Still works though but I'd forgotten how satisfying the feel of manual focus and the sound of a manual shutter sounded.

So off to the supermarket to get some new batteries for it and some film ready for my trip to France in July & August this year.

#pentax #photography #oldschool

Is loving +William Shatner on 'Have I Got News For You'

Independent Movie
I had the pleasure of seeing this great, low budget (£55,000) movie at the Prince Charles Cinema, London on Saturday 19th May with +Angela Connor. Afterwards there was a Q&A session with +Toby Manley of the cast, the director, script writer and the composer of the score.

I love going to the cinema, I enjoy a blockbuster, however it was refreshing to support an independent film, and get to hear from the team behind the credits.

The film follows the antics of two comic store owners. The film is full of classic geeky comic humour. After the screening, during the Q & A, I discovered that the film was shot in a real comic store in Edinburgh, the actual owner of the store has a cameo appearance in the graveyard scene.

The team were so enthusiastic about their project, but I could not help to feel sorry for the fact that, as the director stated, five years ago distribution would not have been an issue. At the moment, the plan is to continue to promote this film on a grass roots level, with screenings in independent cinemas, and revenue coming from pre-sales for the DVD release and merchandise.

Enjoy the trailer and look out for a screening near you, details coming soon on their webiste.. http://electricmanmovie.com/

#independentfilm #electricman #princecharles #movietrailers #scotland

Sexy CPR
Certainly a way to make you remember how to do CPR, a bit better than the recent Vinnie Jones and British Heart Foundation (BHF) 'Hands Only' video!

#cpr #lingerie #sexy #resuscitation

Me and +Angela Connor at the top!

Chromebook

Oh yeah bring it on...

#chromebooks #chromeos

RESHARE:
Amazing footage for the Red Bull Stratos project
#redbull #stratos #spacetravel #felixbaumgartner

Reshared text:

Giant Plug Socket
I saw this up on the side of a building on Ganton Street, London... it amused me but I'd love to know the significance of it. Anyone know?
#londonstreetphotography #london #electricity

#joke

Joke of the Day

Q: What the difference between your girlfriend and your smartphone?

A: Your smartphone constantly gets updates to iron out its faults and your girlfriend just constantly updates you on your faults!! :-)

It works!
#autoawesome

Not sure if this is the right area but anyone able to write the regular expression format for parcelforce deliveries?  The number that I'm trying to turn into a RegEx is IX1234567

Thanks..

Frosty on the motorbike this evening!

Nice :)

This has got to be the weirdest SEO result for one of my sites ever..

Delicious meal !

Me and my giant of a girlfriend +Angela Connor at Inverness Airport

A 3rd of the way down from the top of Ben Nevis with +Angela Connor

On our way up!

I've got one of your tube heaters installed in my conservatory :)

What a great review of our own product :-)

Is happy to finally have Google + enabled for Google Apps users!!

RESHARE:
What an absolutely wonderful article

Reshared text:
Each child of yours, whether a girl or a boy, whether oldest or youngest, whether biological or not, whether near or far—needs you as much they need food or air. You may not be perfect, you may not have all the answers, but your children need you. Mothers are important and necessary for their part and so are you. Don’t stop what you are doing, never give up, always stay connected to your kids no matter what. Your kids may never actually thank you if you do, but they will have a Daddy-shaped hole in their hearts until they day they die if you don’t.

Dads, you matter more than you know.

WOW - absolutely amazing!

If you submit products to Google Shopping and use the Taxonomy you may have noticed that the great little search tool that Google offered has now gone and no one knows where!  Fear not though, just found this cool little tool thats been created by Celebird who some of you may know from the Google Shopping forums.

#googleshopping   #taxonomy   #search  

After a week off I've now been waiting 8 minutes for Microsoft Windows 7 to complete all its updates!

Quote of the day
If the love within your mind is lost and you see other beings as enemies, then no matter how much knowledge or education or material comfort you have, only suffering and confusion will ensue. - Dalai Lama

RESHARE:
How very true!

Reshared text:

RESHARE:


Reshared text:
The Power of Human Determination - We All Have It, But Not All Use It

Here's the power of human determination -- After her plane crashes, a seventeen-year-old girl spends eleven days walking through the Peruvian jungle. Against all odds, with no food, shelter, or equipment, she gets out. A better-equipped group of adult survivors of the same crash sits down and dies. What makes the difference? (from Deep Survival: Who Lives, Who Dies, and Why by Laurence Gonzales)

I heard a survivor of the Oklahoma tornado this week describe the intense fear that he was going to die while the tornado ripped away the house he was lying in, but at the same time he told himself over and over "this is not how I'm going to die." That's human determination.

It's not just extreme survival situations where we need to use human determination. I'm counseling people right now who are using it -- a man who's fighting to have a relationship with his kids despite every attempt by his ex to keep them from him; a woman battling the emotional toll of being out of work for 9 months, getting rejected over and over again by employers, but still looking for work; men and women discovering who they'll be in the next stage of their lives after divorce, cancer surgery, the kids have moved out.

Human determination, we all need it, and we all have access to its power, we just have to chose to use it.

#powerofthemind   #selfdetermination   #powerofthought  Image: http://goo.gl/w3Uq5