< >
Hello, guest! Please log in or register.

The PokéCommunity

Go Back     The PokéCommunity Forums > Members List Overlord Drakow's Profile

Notices

Overlord Drakow's Profile Picture

Overlord Drakow Overlord Drakow is offline

-CONQUERER

Visitor Messages

Showing Visitor Messages 751 to 765 of 3513
  1. Sheep
    April 5th, 2013 9:37 AM
    Sheep
    happy birthday wow I didn't even realize yours was April too :O
  2. Avishka
    April 5th, 2013 2:25 AM
    Avishka
    Happy bday!! :D
  3. Echidna
    April 4th, 2013 11:25 PM
    Echidna
    Asdf happy birthday!
  4. Overlord Drakow
    April 4th, 2013 4:21 AM
    Overlord Drakow
    DECLARE @Customer varchar(160)
    DECLARE @Postcode varchar(20)
    DECLARE @Module varchar(200)
    DECLARE @Price int

    DECLARE compare CURSOR
    FOR
    Select distinct Customer, Postcode, Module, Price from dbo.SSTable
    Open compare

    Fetch next from compare into @Customer, @Postcode, @Module, @Price

    while @@FETCH_STATUS = 0
    Begin

    insert into dbo.CursorResults (Customer, Postcode, Module, Price)
    Select Customer, Postcode, @Module, @Price from dbo.CRMTable
    where (Customer = @Customer OR Customer IS NULL)
    AND (Postcode = @Postcode OR Postcode IS NULL)

    Fetch next from compare into @Customer, @Postcode, @Module, @Price
    END

    CLOSE compare
    DEallocate compare
  5. Overlord Drakow
    April 4th, 2013 2:49 AM
    Overlord Drakow
    DECLARE @Customer varchar(160)
    DECLARE @Postcode varchar(20)

    DECLARE compare CURSOR
    FOR
    Select distinct top 300 Customer, Postcode from dbo.SSTable
    Open compare

    Fetch next from compare into @Customer, @Postcode

    while @@FETCH_STATUS = 0
    Begin

    insert into dbo.CursorResults (Customer, Postcode, Module, Price)
    Select Customer, Postcode, Module, Price from dbo.CRMTable
    where (Customer = @Customer OR Customer IS NULL)
    AND (Postcode = @Postcode OR Postcode IS NULL)

    Fetch next from compare into @Customer
    END

    CLOSE compare
    DEallocate compare
  6. Cherrim
    April 3rd, 2013 9:19 PM
    Cherrim
    Wow, on his first playthrough??
  7. Esper
    April 3rd, 2013 12:01 PM
    Esper
    But it's the things you're special for that make you unique... and special. I'm so eloquent today.
  8. House
    April 3rd, 2013 10:20 AM
    House
    Hi, sir Overlord!

    I guess you could say, I am yes! But I'm definitely not a professional, since I believe I lack the skills and I'm still far away from college. Yeah, I've seen you posted some bits of code on your profile. Do you get to tell people "Did you try turning it off and on again?" IT Crowd style?
    Piano, cool! I studied piano/keyboard for 4 years and guitar for 2, but now I just played a bit of keyboard now and then... Which bands or songs are you into?

    I haven't been doing a lot lately, really. Just studying a lot and learning Polish. It's a fun but relatively difficult language. The words change depending on the grammatical case, so that's kind of confusing.
  9. Overlord Drakow
    April 3rd, 2013 4:47 AM
    Overlord Drakow
    DECLARE @Customer varchar(100)

    DECLARE compare CURSOR
    FOR
    Select top 100 LEFT(Customer, 10) from dbo.SSTable
    Open compare

    Fetch next from compare into @Customer

    while @@FETCH_STATUS = 0
    Begin

    insert into dbo.CursorResults (Customer)
    Select LEFT(Customer, 10) from dbo.CRMTable
    where (LEFT(Customer, 10) = @Customer OR LEFT(Customer, 10) IS NULL)

    Fetch next from compare into @Customer
    END

    CLOSE compare
    DEallocate compare
  10. Overlord Drakow
    April 3rd, 2013 2:55 AM
    Overlord Drakow
    DECLARE @Customer varchar(100)

    DECLARE compare CURSOR
    FOR
    Select LEFT(Customer, 10) from dbo.SSTable
    Open compare

    Fetch next from compare into @Customer

    while @@FETCH_STATUS = 0
    Begin

    insert into dbo.CursorResults (Customer)
    Select Customer from dbo.CRMTable
    where (Customer = @Customer OR LEFT(Customer, 10) IS NULL)

    Fetch next from compare into @Customer
    END

    CLOSE compare
    DEallocate compare
  11. Overlord Drakow
    April 3rd, 2013 2:34 AM
    Overlord Drakow
    DECLARE @Customer varchar(100)

    DECLARE compare CURSOR
    FOR
    Select top 30 Customer from dbo.SSTable
    Open compare

    Fetch next from compare into @Customer

    while @@FETCH_STATUS = 0
    Begin

    insert into dbo.CursorResults
    (Select Customer, PostCode from dbo.CRMTable
    where (Customer = @Customer OR LEFT(Customer, 10) IS NULL))

    Fetch next from compare into @Customer
    END

    CLOSE compare
    DEallocate compare
    otherwise you'll have to declare local variables to hold the PostCode (varchar x)
    and then the select is something like:
    select @Customer=Customer, @Postcode=Postcode FROM dbo.CRMTable WHERE ...
    then your insert is INSERT INTO dbo.CursorResults (Customer, Postcode) VALUES (@Customer, @Postcode)
    if it works then the INSERT INTO (SELECT ...) will do it all in one go for you (no need for row count then)
  12. Overlord Drakow
    April 3rd, 2013 2:25 AM
    Overlord Drakow
    DECLARE @Customer varchar(100)



    DECLARE compare CURSOR
    FOR
    Select top 30 Customer from dbo.SSTable
    Open compare
    Fetch next from compare into @Customer
    while @@FETCH_STATUS = 0
    Begin
    Select Customer from dbo.CRMTable
    where (Customer = @Customer OR LEFT(Customer, 10) IS NULL)
    IF @@ROWCOUNT > 0
    Begin
    insert into dbo.CursorResults Customer
    VALUES @Customer
    END
    Fetch next from compare into @Customer
    END
    CLOSE compare
    DEallocate compare
  13. House
    April 2nd, 2013 5:14 PM
    House
    That's quite nice. I haven't seen a lot of people here who like Math, kinda sad...
    So hi! I'm Gabriel and my friends don't know calculus yet. Silly friends. How are you?
  14. Esper
    April 2nd, 2013 12:07 PM
    Esper
    I'm sure you are. Mathematics and martial arts are already beyond 90% of people.
  15. Esper
    April 2nd, 2013 10:56 AM
    Esper
    You're unique. Just like everybody else.

About Me

  • About Overlord Drakow
    Biography
    Allow me to introduce myself.

    I am the Absolute Supreme Overlord of Darkness. My purpose in this life is to rule the universe! The Darkness pulses through my veins granting me ultimate POWER! Embrace the Darkness! Defeat the Divine Light! For the Light blinds the human mind and causes humans to act recklessly on emotion. Dark Justice is absolute; it forgoes emotion and relies purely on logically constructed facts and assumptions. No matter how fast Light travels, Darkness will always be waiting.

    All of the fools who dare oppose my absolute supremacy, shall suffer my overwhelming wrath in the eternally black abyss of hell! The icing terror of despair shall sink into the souls of my enemies as the blackest darkness covers this planet. Numbed with fear, they watch helplessly as the Dark lord rises to power. For dominance is not enough - I demand Absolute Supremacy! There is No Hope in Hell for those who pointlessly stand against me.
    Interests
    Universal domination
    Karate
    Anime
    Video games (PS3, PSP, DS)
    Piano
    Cycling
    Travelling
    Location
    Hell
    Occupation
    Supreme Overlord.
    Nature
    Serious
    Also Known As
    The Overlord
    Favorite Pokémon
    Hydreigon
    Haxorus
    Scrafty
    Garchomp
    Tyranitar
    Magnezone

    Dark and Dragon types in general.
    Twitter
    Overlord_Drakow
  • Signature
    "Power through ambition." - Overlord Drakow
    Forum Set // Pair

Statistics

Total Posts
Activity by Forum
Visitor Messages
General Information
  • Join Date: October 4th, 2007
  • Referrals: 2

Friends

Showing Friends 1 to 18 of 18
  • Abnegation
    • Abnegation
    • [span="color: #CE1B1B; font-size: 11px; font-family: 'poppins';"]ATTACK[/span]on[span="color: #CE1B1B; font-size: 11px; font-family: 'poppins';"]TITAN[/span]
    • Abnegation is offline
  • Ash
    • Ash
    • [span=font-size: 14px; letter-spacing: 1px; font-family:Alegreya Sans SC;color:#03 0303;line-height:90%;text-shadow: 1px 1px 1px rgba(0,0,0,0.1);][i][b]→ ring a [color=#826c77][FONT=Satisfy]bell[/FONT][/i][/b][/color][/span]
    • Ash is offline
  • bobandbill
    • bobandbill is offline
  • Captain Fabio
  • Cherrim
  • donavannj
  • Esper
    • Esper
    • my user title got ate :(
    • Esper is offline
  • Ivysaur
    • Ivysaur is offline
    • Send a message via Skype™ to Ivysaur
  • Kirby
    • Kirby
    • [color=#accdff][b]ニンフィア[/b][/color]
    • Kirby is online now
  • Kura
    • Kura
    • twitter.com/kuraberrym
    • Kura is offline
  • Livewire
    • Livewire is offline
  • Ludger
    • Ludger
    • [size=1][color=#000000][i]side[/i] [b]to[/b] [i]side[/i][/color][/size]
    • Ludger is offline
  • Morkula
    • Morkula is offline
  • Nakasu
  • Razor Leaf
    • Razor Leaf is online now
  • rikadventure
    • rikadventure
    • [span=font-size: 12px;color:#4780A6; line-height:11px;text-shadow: 1px 1px 0px #ffffff;font-family: courier new;]➟ [b]every story[/b][/span]
    • rikadventure is online now
  • SoapyBubbles
    • SoapyBubbles is offline
  • TwilightBlade
    • TwilightBlade is offline

Emblems

Emblem Showcase - 30 Total
  Emblem
E3-11
You nerded out to the 2011 E3 Expo!
Awarded: June 7th, 2011 2:03 PM
Community supporter
These helpful members donate their money to help make PC a better place.
Awarded: June 18th, 2011 9:16 AM
PC Veteran
These old folks have been around for far too long but we love them anyway.
Awarded: June 23rd, 2011 6:39 AM
Crazy, crazy member
There's nothing more to say.
Awarded: June 26th, 2011 9:07 AM
Your Love is My Drug
Tonight we're going hard and if I were you, I'd take this as a VIP invitation.
Awarded: July 3rd, 2011 7:33 PM
Limited Edition Get-Together 8 Mint
This member joined us for a healthy discussion in the Get-Together 8's IRC Chatterbox!
Awarded: July 21st, 2011 6:38 AM
Seasonal Photography Participant
No awesome descriptions or anything, but you participated in the Get-Together 8 event and hopefully next time you'll be a winner.
Awarded: August 18th, 2011 6:04 PM
Getting Better!
You have won the second place in the PokéCommunity Get-Together 8 Pokédex 3DSnap Category A! Looks like you're showing a bit of your teeth now, eh? Did you enjoy the time in the event?
Awarded: August 18th, 2011 11:57 PM
The Perfect Image Enhancer!
Oh my goodness, you actually did it and became the winner in the PokéCommunity Get-Together 8 Pokédex 3DSnap Category C! All your skills combined have made it possible for the greatest honour! Feel free to spend your time staring at this shiny new emblem!
Awarded: August 18th, 2011 11:59 PM
2D in my 3D world?
Somehow, your result looked like a cardboard cutout in a 3D world... and it sure looks funny! Might as well as enjoy this acquisition for the PokéCommunity Get-Together 8 Pokédex 3DSnap, eh?
Awarded: August 18th, 2011 11:59 PM
The Broken Pencil
You didn’t win, but now you have something else to rant about! [Get-Together 8 Blog Competition Participant]
Awarded: August 19th, 2011 12:06 AM
The Master of Disguise
We really thought you were that Pokemon! [Get-Together 8 Pokemon Cosplay Contest Winner]
Awarded: August 19th, 2011 12:12 AM
Pyramid Head's Approval
Pyramid Head doesn't hate you. But he doesn't like you. At least you are still alive... For now...
Awarded: August 24th, 2011 8:03 AM
Participant of the GT8 Tours
Piplup is interested in your true potential, we know you have it in you!
Awarded: September 15th, 2011 10:20 AM
NONONO
Stop asking or this is the last emblem you'll get.
Awarded: December 8th, 2011 1:45 AM
Ain't got no chat in here :P
Gee, even though the chat's probably deader than dead at times, you still participated in the Holiday Hop's Holiday Skype!
Awarded: January 4th, 2012 4:13 AM
Still finding your way
You participated in Winter Photography during the Holiday Hop. Maybe next time you'll find your way to a nice cozy cabin!
Awarded: January 8th, 2012 7:34 PM
Member of the Year All-stars
You may not have won Member of the Year in Member of the Year, but you did place something in Member of the Year for one year.
Awarded: January 8th, 2012 8:00 PM
Not in for the Coffee
This member frequents PokéCommunity Live. Something tells us that it's not for a latte or to watch the awesome gigs inside.
Awarded: January 9th, 2012 8:37 AM
Chit-Chatterbox
You always have a word or two about Pokémon to share with us. Is that all you think about?
Awarded: March 9th, 2012 7:44 AM
The 1000-line Order
This #thepokecommunity chatter has said over 1000 lines at the chat. Talk about an active chatter!
Awarded: March 26th, 2012 5:03 AM
Do the Creep
For those of us that do the creep, whether or not it be intentional! Do the creep, huuuuuuh!
Awarded: May 22nd, 2012 8:07 PM
iStalker
You’ve obviously been taking lessons from Went.
Awarded: May 22nd, 2012 11:38 PM
Master Deckbuilder!
You took first place in one of PC's deckbuilding competitions! You just may be the best there is!
Awarded: September 9th, 2012 8:56 PM
#thepokecommunity was glad to have you
Thanks for participating in the fun at #tpc during PCX!
Awarded: November 18th, 2012 2:56 AM
Green's Chatty Gossip Award
This member has been acknowledged as one of PokéCommunity Live's most chattiest. Wonder what Green thinks?
Awarded: December 24th, 2012 4:01 PM
Zapping The World By Storm
This member helped to make the Pokémon X and Pokémon Y forum a huge initial success.
Awarded: January 8th, 2013 5:35 AM
Good friends
are those who stick together When there's sun and in the heavy weather... someone is ready to go where dreams come true with you!
Awarded: August 5th, 2013 9:10 PM
Committed
You've kept the same pair for over a year. The worst is now over! Wait... wasn't this just supposed to be for fun?
Awarded: December 2nd, 2013 10:58 AM
Badass Battler
This member participated in three of the Battle Center's Community Days. We hope to see you more!
Awarded: December 27th, 2013 1:16 PM

  All times are GMT -8. The time now is 10:37 AM.


Contact Us Archive Privacy Statement Terms of Service Top