Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raggamuffin
Starting Member
1 Post |
 Posted - 2009-07-08 : 02:34:19
|
| I have three separate queries that I hope someone can respond to. You can make up values as part of the SQL statements.1) Create an SQL to show the product names, quantity ordered, selling price and total value sold per product in order number 12342) A query that will retrieve the name and phone extension for a supervisor of an employee who has processed the order number 12343) SQL to retrieve names of customers that have not made a purchase during the recent most calendar month. Do not hard code a month start/end value, has to be able to run without recoding.Thank you,-Tina |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-08 : 02:41:07
|
| It Seems your Home work practice and learn yourself ! ;)Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 11:02:37
|
quote:
Originally posted by raggamuffin
I have three separate queries that I hope someone can respond to. You can make up values as part of the SQL statements.1) Create an SQL to show the product names, quantity ordered, selling price and total value sold per product in order number 12342) A query that will retrieve the name and phone extension for a supervisor of an employee who has processed the order number 12343) SQL to retrieve names of customers that have not made a purchase during the recent most calendar month. Do not hard code a month start/end value, has to be able to run without recoding.Thank you,-Tina
start with belowhttp://www.w3schools.com/sql/ |
|
|
|
|
|
|
3 Queries