Question about Microsoft Computers & Internet

1 Answer

SQL IF ONE table contains prouduct id,total value and another table contain product sale ,date of sale ,number of product sale if the number product sale is add one more than the number of product is increamented by one,and alse totalvalue is also increamented by one ,how to wrote the query for this problem

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 36 Answers

Select productid, numberofproduct+2, totalvalue + 1
from
table1, table2
where table1.productid = table2.productid
group by productid

Posted on Jul 26, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Sum numbers in a column down until you come to a blank, then start again


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

1 Answer

How to change the date of an invoice


If you have already closed the invoices and cannot void them, then you need someone to adjust their date in the database. If you can void them, then change the date of the computer to the date you want on invoice and reenter invoice. This can't be done if it was a credit card sale however. Don't forget to change back the system date.
The first solution involves several tables in database and should only be attempted by someone familiar with SQL and RPE database. I could help.
sysadmin@ccybernet.com
Please return and give me a favorable rating if this helps or is of value to you.
Feel free to email me with more details if need be.

Dec 14, 2011 | Pc America Restaurant Pro Express

1 Answer

Lucky draw coding


You need two things:
1. JSP/Servlet knowledge.
2. SQL Programming basics

1. Create your PR jsp page which contain a form with method post and action to a servlet that will handle the insertion of the data to a database table i would add winners table containing ID, Frkey, thenumber

2. A servlet that will generate the number and cross check with those who guessed right and update the winners table with that data.

3. A servlet that will do an inner join with the pr and winners tables to display the results.

Good luck

Apr 05, 2010 | Sun Java Programming Language (cdj-275)

1 Answer

Sql queries for edit the tables dipendra


This is a generic Update(edit) statement in SQL:

UPDATE [tablename]
SET [columnname] = [new value]
WHERE [columnname] = [old value]

tablename = the name of the table you want to edit
columnname = name of column to be updated

Mar 15, 2009 | Microsoft Computers & Internet

1 Answer

How to create a multiple access query and put altogether into 1 SQL Scrip(.sql file)


Suggest using Union Query. Thus, you can add more queries from many table and the output will be in one (1) query. Bear in mind that all fields must have same Field Name.

For example:
tblOne contains dtDate1 fieldname. Your query will select [tblOne].[dtDate1] As myDate.
tblTwo contains dtDate2 fieldname. Your query will have the following SQL:

Select [tblOne].[dtDate1] As myDate
UNION Select [tblTwo].[dtDate2] as myDate

Thus the output will result dates from tblOne and tblTwo in a column called myDate.

Regards,
Maha

Feb 05, 2009 | Microsoft Computers & Internet

1 Answer

HLOOKUP IN MS EXCEL


lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Computers & Internet

1 Answer

UPDATE DATA WINDOW IN PB 11 ERROR


It is probably a string column, being updated with a longer string than it can contain.
Date time columns may also cause this.
If you know the exact SQL update statement you can send it here.
If not, you may consider trapping it with Profiler.
*********CAUTION - if you have a production server with multiple customers depending on its availability, do not try profiler without guidence ********************

If you are the programmer, we may consider changing the field type or truncating the string, acording to the applicational needs.

Aug 21, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Excel counting


Use Pivot table, it might help you reach your target..!!

Aug 12, 2008 | Microsoft Excel for PC

1 Answer

How to compare a value in a subform with parent form's value in Dcount


Assuming that Process id is an integer, this should do the trick:

DCount("[stageid]", "Process Stages", "[Process id] = " & Me.Parent! [Process id])

Regards -- Joe (Access VBA samples)

May 01, 2008 | Microsoft Office Access 2003 (077-02871)...

3 Answers

Viewing ms Sql Server database on Access


Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

207 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...