<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
T-SQL (SS2K5)
»
Item grouping for packing slips
Item grouping for packing slips
Rate Topic
Display Mode
Topic Options
Author
Message
justforgroups2004
justforgroups2004
Posted Monday, November 05, 2012 10:49 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, November 06, 2012 7:44 AM
Points: 13,
Visits: 126
Hi Everybody
We ship books - no more than 10 books per box. And Other items (toys, etc.) – no more than 15 pounds per box. Books are shipped separately from Other items. But orders usually contain a mix of items (let's say: 28 Books and 34 pounds of Other items).
Is there a way to create a packing slip for every box? In the case described above:
- Two boxes with 10 books each
- One box with 8 books
- Two boxes with 15 pounds of Other items each
- One box with 9 pounds of Other items
Thank you!
Post #1381378
Phil Parkin
Phil Parkin
Posted Monday, November 05, 2012 11:04 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 9:19 AM
Points: 4,234,
Visits: 9,469
justforgroups2004 (11/5/2012)
Hi Everybody
We ship books - no more than 10 books per box. And Other items (toys, etc.) – no more than 15 pounds per box. Books are shipped separately from Other items. But orders usually contain a mix of items (let's say: 28 Books and 34 pounds of Other items).
Is there a way to create a packing slip for every box? In the case described above:
- Two boxes with 10 books each
- One box with 8 books
- Two boxes with 15 pounds of Other items each
- One box with 9 pounds of Other items
Thank you!
Based on the information that you have provided, I'd say that the answer is yes.
But if you want a technical solution, you'll have to provide sample data, DDL, desired output - see the link in my signature for details.
____________________________________________________________________________________________
Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.
Post #1381382
justforgroups2004
justforgroups2004
Posted Tuesday, November 06, 2012 1:20 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, November 06, 2012 7:44 AM
Points: 13,
Visits: 126
Thank you for reply, Phil!
Here's the data generator. Still working on the output.
---------------------
CREATE TABLE [dbo].[Orders](
[OrderNumber] [int] NOT NULL,
[ItemNumber] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemDescription] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Book] [int] NULL,
[OtherItem] [int] NULL,
[WeightEach] [decimal](20, 8) NULL,
[NumberOfPieces] [int] NULL
) ON [PRIMARY]
---------------------
INSERT INTO orders
(OrderNumber,ItemNumber,ItemDescription,Book,OtherItem,WeightEach,NumberOfPieces)
SELECT '1','ku85487','Dr. Seuss','1','0','0.00000000','30' UNION ALL
SELECT '1','w5647f','Perplexus Maze Game','0','1','5.00000000','2' UNION ALL
SELECT '1','lk875fc','Llama Llama','1','0','0.00000000','9' UNION ALL
SELECT '2','547juy0','Where the Wild Things Are','1','0','0.00000000','6' UNION ALL
SELECT '2','ikj75254','Pete the Cat','1','0','0.00000000','8' UNION ALL
SELECT '2','hytr54','Happy Birthday to You','1','0','0.00000000','10' UNION ALL
SELECT '2','58jkjhyt','Spot It','0','1','3.00000000','4'
---------------------
Post #1381433
mmartin1
mmartin1
Posted Tuesday, November 06, 2012 11:56 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:43 PM
Points: 192,
Visits: 640
Hi - If I understood correctly :
It looks like your first step is a [boxes] entity/table.
A stored procedure could go through the order, determine how many boxes are needed then create and assign a book or other item to the appropriate box ID .You can then insert the pair (book1, box1).. into a item-Box transactions table. You should have a field in the box table to identify what type of items it holds (books/..) as well.
Post #1381681
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
