Viewing 15 posts - 7,561 through 7,575 (of 15,381 total)
I am not sure exactly what you are looking for but I think this is close based on your original post.
select o.ID as OrderID, oi.ItemNumber as ItemOrdered, oi.QtyToShip as QuantityOrdered,
sa.ProductCode...
July 12, 2013 at 10:58 am
If you can turn your last posting of data into inserts I will be happy to help you figure out your query. 🙂
July 12, 2013 at 10:22 am
kaminskidevelopment (7/12/2013)
Yours is much more consumable - is there a reference for the shortcodes? Please forgive my haphazard posting, I sincerely appreciate your help.
Not sure what you mean by a...
July 12, 2013 at 10:04 am
WolfgangE (7/12/2013)
The object explorer might throw some errors when expanding the different trees...
July 12, 2013 at 10:01 am
kaminskidevelopment (7/12/2013)
Let me get some better IDs for you - I just used some top IDs
I put together an example of how you should post this stuff. It needs to...
July 12, 2013 at 9:59 am
kaminskidevelopment (7/12/2013)
The naming conventions are poor.The order connects to the shipment via the PO - PO in shipping is the OrderRef1 in the ORDER table
So in your sample data neither...
July 12, 2013 at 9:49 am
kaminskidevelopment (7/12/2013)
What do you mean by expected results?
That means that based on your sample data what should the desired output be. Yours is reasonably easy enough to figure that out...
July 12, 2013 at 9:47 am
How do you know which order a shipment is for? I don't see anything that connects those together.
July 12, 2013 at 9:36 am
sharonsql2013 (7/12/2013)
Can I view the schema names in asc order?
It is just a query so you can order the results just like any other query.
July 12, 2013 at 9:21 am
sharonsql2013 (7/12/2013)
Hi,How can I calculate total # of schema's present in a Database?
select * from sys.schemas
July 12, 2013 at 9:11 am
kaminskidevelopment (7/12/2013)
Is there any quick/easy way to pull these out of SQL Management Stuido, or do I have to hand write these statements...
July 12, 2013 at 9:10 am
Charles Deaton (7/12/2013)
July 12, 2013 at 9:00 am
Hi and welcome to the forums. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form...
July 12, 2013 at 8:59 am
huum (7/12/2013)
I am trying to completely uninstall sql server 2008 from my computer.i removed all files from control panel,
removed directories but its still there
What do you mean it is still...
July 12, 2013 at 8:57 am
Glad you got it sorted out but...I don't see why you need a loop for this at all.
I am pretty sure you could replace your entire script with a single...
July 12, 2013 at 8:23 am
Viewing 15 posts - 7,561 through 7,575 (of 15,381 total)