Login or Register to Ask a Question and Join Our Community


Homework & Coursework Questions

Queries

Login to Discuss or Reply to this Discussion in Our Community

 
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

LEARN ABOUT PHP

win32_query_service_status

WIN32_QUERY_SERVICE_STATUS(3)						 1					     WIN32_QUERY_SERVICE_STATUS(3)

win32_query_service_status - Queries the status of a service

SYNOPSIS

       mixed win32_query_service_status (string  $servicename, [string	$machine])

DESCRIPTION

	Queries the current status for a service, returning an array of information.

PARAMETERS

	      o $servicename
		- The short name of the service.

	      o $machine
		- The optional machine name. If omitted, the local machine will be used.

RETURN VALUES

	Returns an array consisting of the following information on success, FALSE if there is a problem with the parameters or a Win32 Error Code
       on failure.

	      o $ServiceType
		- The dwServiceType. See Win32Service Service Type Bitmasks.

	      o $CurrentState
		- The dwCurrentState. See Win32Service Service Status Constants.

	      o $ControlsAccepted
		- Which service controls are accepted by the service. See Win32Service Service Control Message Accepted Bitmasks.

	      o $Win32ExitCode
		- If the service exited, the return code from the process.

	      o $ServiceSpecificExitCode
		- If the service exited with an error condition, the service specific code that is logged in the event log is visible here.

	      o $CheckPoint
		- If the service is shutting down, holds the current check point number. This is used by the SCM as a kind of heart-beat to detect
		a wedged service process. The value of the check point is best interpreted in conjunction with the WaitHint value.

	      o $WaitHint
		-  If the service is shutting down it will set WaitHint to a checkpoint value that will indicate 100% completion. This can be used
		to implement a progress indicator.

	      o $ProcessId
		- The Windows process identifier. If 0, the process is not running.

	      o $ServiceFlags
		- The dwServiceFlags. See Win32Service Service Service Flag Constants.

SEE ALSO

       Win32Service Predefined Constants.

PHP Documentation Group 											     WIN32_QUERY_SERVICE_STATUS(3)