Queries

 
Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions Queries
# 1  
Old 02-23-2010
Queries

Any help on like where to get started on this? I'm just confused.

1. The problem statement, all variables and given/known data:
Enter text here.Queries to satisfy these two report requests (use your CCI database):
  1. Retrieve all rows of active inventory where current on hands is less than minimum level. Create a field in the results that computes the difference between the max and current on hands. Name this field "ReorderQuantity". Include vendor info to make reordering easier. --Hint: see page 110 in the Visual Quickstart textbook.
  2. Number of all Vendors that are not the preferred vendor that supply products for CategoryId 2. Exclude all disabled products and those introduced into the system prior to 2007.




2. Relevant commands, code, scripts, algorithms:
idk




3. The attempts at a solution (include all code and scripts):
dunno, need help start




4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Kansas State, Manhattan, KS Brian Hucklebee CS146
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. IP Networking

RDNS Queries

Hey everyone, I have a question, I've been playing around with tcpdump, and noticed my machine making numerous rdns look ups. They are displayed like: 10.80.80.141.51234 > 10.80.80.1.domain: 9950+ PTR? 223.114.55.65.in-addr.arpa. (44) My question is, if dns works based on numerical... (0 Replies)
Discussion started by: Lost in Cyberia
0 Replies

2. Red Hat

NFS Queries

Hi, I would like to know on one server how many mouting can be done? wheather there is limitation on number of mounting? wheather it is possible to increase NFS Performance? if yes then which parameters needs to given while mounting? (3 Replies)
Discussion started by: manoj.solaris
3 Replies

3. UNIX for Dummies Questions & Answers

FTP Queries

Hi, 1) How to get exact permissions, group names for files while transferring with FTP 2) Is there any command to transfer entire directory and sub directories. Thanks (1 Reply)
Discussion started by: nag_sathi
1 Replies

4. Shell Programming and Scripting

Crontab queries

Hi Expert, How to schedule a job on last day of the month. Need your kind help. Regards, PK (3 Replies)
Discussion started by: pkrabi78
3 Replies

5. UNIX for Advanced & Expert Users

How many DNS queries

Is there any way to see how many queries come into our external DNS server? In looking at DNS providers, most of them base pricing on number of queries per month so I just wanted to see if you had any idea/way of gathering that data? A rough ballpark figure would even work. Our DNS server is... (1 Reply)
Discussion started by: raggmopp
1 Replies

6. Programming

Combine 3 queries

can these 3 be combined into 1 query? createtablea1as selecta.tps_Res_nb, b.tkt_prod_cd, b.tkt_prod_typ_nm, b.prod_intrnl_ds, b.tkt_prod_typ_nm AS TKT_ENTL_NM, casewhen b.tkt_prod_nm isnotnullthen b.tkt_prod_nm when b.tkt_prod_nm isnulland b.prod_intrnl_ds isnotnullthen... (1 Reply)
Discussion started by: dwr80
1 Replies

7. Shell Programming and Scripting

queries about exit

hi all, please tell me clearly the difference between exit 1 and exit 2 one more question i want to know the difference between some basic shells like bsh, csh, ksh, bash. i refered in net i get wast of text pages can any one give me any link to show the diff precisely or any blogs.... (2 Replies)
Discussion started by: Arunprasad
2 Replies

8. Shell Programming and Scripting

my queries

hi guys Well, i need to have a report generation script or any script which will show me all the content/information of a file when i run that script. Please help me on this isssue at the earliest.As i am little bit aware of scripting.Thanks in advance! regards ash (4 Replies)
Discussion started by: whizkidash
4 Replies

9. UNIX for Advanced & Expert Users

Some queries...

Guys need some advice on how to check some of the questions below? i'm running on an open VMS platform... which i am an idiot to... appreciate if anyone can give some hints or source on how to check on.. a script that is running on cron job... but doesn't run as the login user name.. 1. why... (6 Replies)
Discussion started by: 12yearold
6 Replies
Login or Register to Ask a Question
__gnu_pbds::sample_resize_trigger(3cxx) 								   __gnu_pbds::sample_resize_trigger(3cxx)

NAME
__gnu_pbds::sample_resize_trigger - SYNOPSIS
Public Types typedef std::size_t size_type Public Member Functions sample_resize_trigger () sample_range_hashing (const sample_resize_trigger &) void swap (sample_resize_trigger &) Protected Member Functions bool is_grow_needed (size_type size, size_type num_entries) const bool is_resize_needed () const void notify_cleared () void notify_erase_search_collision () void notify_erase_search_end () void notify_erase_search_start () void notify_erased (size_type num_entries) void notify_externally_resized (size_type new_size) void notify_find_search_collision () void notify_find_search_end () void notify_find_search_start () void notify_insert_search_collision () void notify_insert_search_end () void notify_insert_search_start () void notify_inserted (size_type num_entries) void notify_resized (size_type new_size) Detailed Description A sample resize trigger policy. Definition at line 48 of file sample_resize_trigger.hpp. Member Typedef Documentation typedef std::size_t __gnu_pbds::sample_resize_trigger::size_type Size type. Definition at line 52 of file sample_resize_trigger.hpp. Constructor &; Destructor Documentation __gnu_pbds::sample_resize_trigger::sample_resize_trigger () Default constructor. Member Function Documentation bool __gnu_pbds::sample_resize_trigger::is_grow_needed (size_typesize, size_typenum_entries) const [inline], [protected] Queries whether a grow is needed. bool __gnu_pbds::sample_resize_trigger::is_resize_needed () const [inline], [protected] Queries whether a resize is needed. void __gnu_pbds::sample_resize_trigger::notify_cleared () [protected] Notifies the table was cleared. void __gnu_pbds::sample_resize_trigger::notify_erase_search_collision () [inline], [protected] Notifies a search encountered a collision. void __gnu_pbds::sample_resize_trigger::notify_erase_search_end () [inline], [protected] Notifies a search ended. void __gnu_pbds::sample_resize_trigger::notify_erase_search_start () [inline], [protected] Notifies a search started. void __gnu_pbds::sample_resize_trigger::notify_erased (size_typenum_entries) [inline], [protected] Notifies an element was erased. void __gnu_pbds::sample_resize_trigger::notify_externally_resized (size_typenew_size) [protected] Notifies the table was resized externally. void __gnu_pbds::sample_resize_trigger::notify_find_search_collision () [inline], [protected] Notifies a search encountered a collision. void __gnu_pbds::sample_resize_trigger::notify_find_search_end () [inline], [protected] Notifies a search ended. void __gnu_pbds::sample_resize_trigger::notify_find_search_start () [inline], [protected] Notifies a search started. void __gnu_pbds::sample_resize_trigger::notify_insert_search_collision () [inline], [protected] Notifies a search encountered a collision. void __gnu_pbds::sample_resize_trigger::notify_insert_search_end () [inline], [protected] Notifies a search ended. void __gnu_pbds::sample_resize_trigger::notify_insert_search_start () [inline], [protected] Notifies a search started. void __gnu_pbds::sample_resize_trigger::notify_inserted (size_typenum_entries) [inline], [protected] Notifies an element was inserted. the total number of entries in the table is num_entries. void __gnu_pbds::sample_resize_trigger::notify_resized (size_typenew_size) [protected] Notifies the table was resized as a result of this object's signifying that a resize is needed. __gnu_pbds::sample_resize_trigger::sample_range_hashing (const sample_resize_trigger &) Copy constructor. void __gnu_pbds::sample_resize_trigger::swap (sample_resize_trigger &) [inline] Swaps content. Author Generated automatically by Doxygen for libstdc++ from the source code. libstdc++ Sun Jan 6 2013 __gnu_pbds::sample_resize_trigger(3cxx)