• Replies 8 replies
  • Subscribers 337 subscribers
  • Views 57 views
  • Users 0 members are here
Related

web sales sql query

Randall Mitchell
$organization

OK - you SQL scripting gurus.. I need to run a query that pulls all sales under mos 52 and 57, showing just date and amount. I am sure this is not difficult for those that know how to do this, but I'm not there yet in my SQL knowledge. Would anyone mind assisting me with this easy query?

Parents
  • $organization
    Nice! So many roads, all leading to Rome...

    ________________________________
    From: Tessitura Technical Forum [forums-technical@tessituranetwork.com] on behalf of Brian Pedaci [bounce-brianpedaci3996@tessituranetwork.com]
    Sent: Sunday, August 08, 2010 2:56 PM
    To: Jensen, Chris
    Subject: Re: [Tessitura Technical Forum] web sales sql query


    datename(mm,order_dt) will give you the name of the month...
    From: Chris Jensen
    Sent: 8/5/2010 2:10:27 PM

    Yeah, I agree the month function is a nice choice, but since it only returns a digital month, I tend to use the string method for super-quick code as above to get me to a three-char month in as few lines of code as possible. :-)



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
    ______________________________________________________________________
    This email has been scanned by the MessageLabs Email Security System.
    For more information please visit http://www.messagelabs.com/email
    ______________________________________________________________________
Reply
  • $organization
    Nice! So many roads, all leading to Rome...

    ________________________________
    From: Tessitura Technical Forum [forums-technical@tessituranetwork.com] on behalf of Brian Pedaci [bounce-brianpedaci3996@tessituranetwork.com]
    Sent: Sunday, August 08, 2010 2:56 PM
    To: Jensen, Chris
    Subject: Re: [Tessitura Technical Forum] web sales sql query


    datename(mm,order_dt) will give you the name of the month...
    From: Chris Jensen
    Sent: 8/5/2010 2:10:27 PM

    Yeah, I agree the month function is a nice choice, but since it only returns a digital month, I tend to use the string method for super-quick code as above to get me to a three-char month in as few lines of code as possible. :-)



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
    ______________________________________________________________________
    This email has been scanned by the MessageLabs Email Security System.
    For more information please visit http://www.messagelabs.com/email
    ______________________________________________________________________
Children
No Data