Jump to content

Marc

Active Members
  • Posts

    546
  • Joined

  • Last visited

  • Days Won

    9

Reputation Activity

  1. Like
    Marc got a reaction from AleksRiks in Is facebook just a moaners paradise?   
    I have to admit to not being someone who visits my facebook very often. Mainly chosing to use it for promotion etc. But does anyone else find it to be a place simply for people to moan?
     
    I sit there with facebook open and read my feed and all I see is pretty much "x person has done this" or "I hate xyz"?
     
    The other kinds of posts are things that people are really not interested in. PLEASE I dont want to know every time your baby kicks! LOL
  2. Like
    Marc reacted to ridwan sameer in Avazio?   
    Yup yup, Just wanted some opinions
  3. Like
    Marc reacted to Nathan in Shopping cart software   
    Yes, Magento has a big learning curve, but is one of the most powerful ones I've used.
     
    Shopper Press runs as a theme/plugin on Wordpress, much easier to setup and use.
  4. Like
    Marc reacted to Thomas in Shopping cart software   
    Personally I love IP.Marketplace however this topic might help.
  5. Like
    Marc got a reaction from Nathan in PHP IDE?   
    This is exactly my issue. Debugging the code is a pain in the backside.
     
    If your editing live stuff like that btw, add the ftp addon to notepad++ as you can just open and edit the files direct. Obviously if you have a copy of everything incase of messin up like I do on a regular basis lol
  6. Like
    Marc got a reaction from Nathan in Row number column   
    Thought I would post up a bit of an example on row numbers within MSSQL. This is something that can come in handy in a multitude of senarios and there are a couple of handy things you can do with in sql server.
     
     
    Lets say I have a dataset consisting of just name, value and I want the top 10 with the highest value first along with their rank. This is somewhere that adding a row number would be quite handy.
     
    So do this you would use the following:
     

    SELECT TOP 10 ROW_NUMBER() OVER(ORDER BY value DESC) as RANKING, [name],[value]
     
    This will give me a row number next to each result line when the dataset is ordered by value descending. Top 10 added to give me the top 10 results
     
     
    Now lets go further than this and say we have another column known as dept. This time I want the order of value, but I want it for each department. So sales for example would have 1-x, as would accounts.
     
     

    SELECT TOP 10 ROW_NUMBER() OVER(PARTITION BY dept ORDER BY value DESC) as RANKING, dept, [name],[value]
     
    This will order by dept then by value. The row number will be reset for each dept and therefore giving me a ranking for each department
  7. Like
    Marc reacted to Microsuck in What was the First Programming Language You Learned?   
    PHP is just as much a programming language as VB or Java or C. The medium of which it is interpreted does not change its classification.
  8. Like
    Marc reacted to tetutato in Posting Contest   
    It still requires you to post non-stop at an interval of approx 1 min.
  9. Like
    Marc got a reaction from Nathan in Opinions on My Next Build?   
    In all honesty, looking at that spec the very first thing I would do is knock the ram down by half and spend that on getting an intel chip instead. Having used both I can honestly say the difference between similar (and even sometimes with a lower spec intel) is quite large.
  10. Like
    Marc reacted to Nathan in Please add forum runner/tapatalk   
    I'm on Tapatalk now...
  11. Like
    Marc reacted to Nathan in How did you learn to develop databases?   
    I interviewed for a database developer job about 5 years ago now and knew nothing about it.
     
    I was given the job not making much as it was the trade off for letting me learn. I taught myself with the help of Google and http://www.experts-exchange.com/ . After about 6 months it was easy.
     
    The only way I learned was because I had to solve real problems. At first it was a lot of trial and error, now it's second nature when I have any database related work.
  12. Like
    Marc got a reaction from ssjgoku206 in Hello DB Forums!   
    Welcome to DB from another newbie
  13. Like
    Marc reacted to Nathan in Any Honest Freelancers On?   
    Hey deadmauslov sounds like you just want the accounts created, databases created, and the scripts installed correct? If so it's simple enough I'll get it done for you just send me a PM.
  14. Like
    Marc reacted to Tony in How to Remove Winrar Popup   
    I know that everyone hates it, that if you have ever looked into purchasing the program just laughed when you saw the pricing options.
     
    You're Welcome.
     
    http://geekytweaks.blogspot.com/2009/08/disable-winrar-notification-popup.html
×
×
  • Create New...