Database

21-Jun-07 2:01

Hallo all
I'm having a problem with some data that I've taken from SQL and copied into an Excel spreadsheet.
Please try this and type the following into these cells:

A1 : -982.21
B1 : 908.66
C1 : -73.55
D1 : =IF(A1+B1=C1,"Correct","Incorrect")

D1 shows "incorrect" which doesn't make sense since A1 + B1 does equal C1. This happens on a couple of rows, I've checked and they should show correct. I have also tried using the SUM function instead of adding A1+B1 and I even tried (IF C1-B1=A1) but it didn't work either. I have formatted the columns as decimal numbers.
Am I missing something really simple here?

Any clues would be appreciated
Thanks

There are 10 types of people in the world, those who understand binary and those who dont.

Colin Angus Mackay21-Jun-07 2:18

Colin Angus Mackay

21-Jun-07 2:18

Rounding errors in the calculation are probably the cause. I'd imagine that excel uses decimal numeric type because it is used so much for financial calculations, while the FLOAT type in the database is just that.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Ready to Give up - Your help will be much appreciated.

My website

ScottM121-Jun-07 2:42

21-Jun-07 2:42

I think you're right.
I used the SUM function on -982.21 and 908.66.
I then increased the decimal places on the answer cell to 25 and I saw this
-73.5500000000001000000000000
The previous values don't have anything after their first 2 decimal places so I don't know where that 1 is coming from. Will make a plan though.
Thanks for your help Wink | ;)

There are 10 types of people in the world, those who understand binary and those who dont.

Michael Potter21-Jun-07 11:11

Michael Potter

21-Jun-07 11:11

If you haven't solved it already - Try:

=IF(ROUND(A1+B1-C1,5)=0,"Correct","Incorrect")

ScottM121-Jun-07 19:27

21-Jun-07 19:27

Thanks, I already made SQL do the decision and that works. I tried your formula though and it works great.
Thanks
Scott

There are 10 types of people in the world, those who understand binary and those who dont.

max two records........

Member 387988121-Jun-07 1:34

Member 3879881

21-Jun-07 1:34

guys again I am throwing you the question

salary
====
1000
2000
3000
4000
4500
1500

here i want to show the max value of two records
means want to show 4500 and 4000
how to do that
plz tell me the query
i need urgently...

Magi

WhiteGirl2321-Jun-07 2:00

WhiteGirl23

21-Jun-07 2:00

hi,
first read all the values in a vector and the use array.sort(vector).
then you can take the values.

hope this help.

ScottM121-Jun-07 2:10

21-Jun-07 2:10

Are you sure you can do that? I've never seen anything like that in SQL.

There are 10 types of people in the world, those who understand binary and those who dont.

ScottM121-Jun-07 2:04

21-Jun-07 2:04

Use the TOP keyword like so:
SELECT TOP 2 salary FROM tablename

There are 10 types of people in the world, those who understand binary and those who dont.

N a v a n e e t h21-Jun-07 2:59

N a v a n e e t h

21-Jun-07 2:59

smyers wrote:
SELECT TOP 2 salary FROM tablename

I think you need to sort it in descending order to get the result what author expected

Navaneeth
My Website

ScottM121-Jun-07 3:09

21-Jun-07 3:09

Don't lie, you just made that up.

There are 10 types of people in the world, those who understand binary and those who dont.

N a v a n e e t h21-Jun-07 3:38

N a v a n e e t h

21-Jun-07 3:38

smyers wrote:
Don't lie, you just made that up.

Navaneeth
My Website

N a v a n e e t h21-Jun-07 3:01

N a v a n e e t h

21-Jun-07 3:01

SELECT TOP 2 Salary FROM TableName ORDER BY Salary DESC

Navaneeth
My Website

Datatable Merge IN C#.Net

Sathiyaraj Ganesan21-Jun-07 3:16

Sathiyaraj Ganesan

21-Jun-07 3:16

use

SELECT TOP 2* Salary FROM TableName ORDER BY Salary DESC

Sathiya

northwind database

Sebastian T Xavier21-Jun-07 0:50

Sebastian T Xavier

21-Jun-07 0:50

Hi,

There is sqlserver 2005 installed in my machine. but i am not able to find the northwind database in the management studio . Can anybody help me to find this database. should i install any addiotional files to get northwind database.

Thanks in advance

Sebastian

Re: northwind database

originSH21-Jun-07 0:59

originSH

21-Jun-07 0:59

You need to download them from microsoft's site.

Northwind is for 2000 and whilst it works on 2005 AdventureWorks is the sample designed from 2005 and is the recommended sample.

Northwind[^]

AdventureWorks[^]

Re: northwind database

Sebastian T Xavier21-Jun-07 1:16

Sebastian T Xavier

21-Jun-07 1:16

Thank you very much .

sebastian

Re: northwind database

originSH21-Jun-07 1:23

originSH

21-Jun-07 1:23

no problem Smile | :)

adnanrafiq20-Jun-07 23:31

adnanrafiq

20-Jun-07 23:31

Hi All,

I have two datatables, one datatable named "dtRecords1" gets filled from excel sheet, having column name "Name","Category", and on run time i have added a Identity column to "dtRecords1".

Second Column gets filled from sql server database having three columsn "ID as Identity","Name","Category".

Now i want to merge these two tables, i want this result from merge.

If there are some changes in first datatable, depending upon all columns (comparing all column values) and ID Is same,it should be overwrited, and if there are some new rows these also should be added to the resulted database.

Example:
Datatable1 from excel
ID,Name,Categoey
1,adnan,SE
2,ali,SSE
3,Imran,JSE
Datatable2 From SQL Server DB

ID,Name,Category
1,adnan,SSE
2,ali,SSE

Resulted Datatable

ID,Name,Category
1,adnan,SE -Changed ROw
2,ali,SSE -Unchanged Row
3,Imran,JSE - Newly added Row
Many THanks & Best Regards,
adnan

Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com

Re: Datatable Merge IN C#.Net

ScottM121-Jun-07 2:24

Re: Datatable Merge IN C#.Net

21-Jun-07 2:24

I don't think there is a merge method in the DataTable class, there is in DataSet though if all else fails.
I'm sure you could use importrow though like so:

for (int x = 0; x < datatable2.Rows.Count; x++)
{
   datatable1.ImportRow(datatable2.Rows[x])
}

There are 10 types of people in the world, those who understand binary and those who dont.

adnanrafiq21-Jun-07 3:25

adnanrafiq

21-Jun-07 3:25

I am 100% sure there is method merge in datatable, when i create instance of datatable, press dot, you will also see, merge method.

Will you please help to fullfill the requirment that i have asked in question or explain what you have in this loop.

Many Thanks,
adnna

Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com

Re: Datatable Merge IN C#.Net

ScottM121-Jun-07 3:35