NEW COLUMN BEHAVES MYSTERIOUSLY

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

NEW COLUMN BEHAVES MYSTERIOUSLY

Author

Topic

annamaria
Starting Member

30 Posts

Posted - 2007-04-25 : 05:02:23

review

Nazim
A custom title

1408 Posts

Posted - 2007-04-25 : 07:58:35

Can you please post DDL and some DML Operations . http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

-------------------------
What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-04-25 : 08:03:43

try putting RATE/360.000000*GC_MAT_C as RATEO

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2007-04-25 : 08:10:40

1) I don't recognize TRUNC as a built in SQL SERVER function. Is it new to 2005?
2) Date columns that are numbers are just wrong. There are LOTS of handy ways to use dates, such as getting a difference between them, that are built into the system without having to do 234235646 calculations on them.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-25 : 08:20:46

By any chance, is column GG_MAT_C NULL for the records where incorrect results are shown?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-04-25 : 08:34:27

write 360.000 <- and as many zeroes as you need. play with it.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-25 : 08:41:01

from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82224

quote:
Originally posted by Michael Valentine Jones

If you are using QMF for Windows, that means that you are probably using a DB2 database. This web site deals only with Microsoft SQL Server database questions, so it is very likely that the answers that have been provided will not work with DB2.

If you are using DB2, you should post your questions on a site that answers DB2 questions.

You might try posting your questions on the DB2 forum at
http://www.dbforums.com/

CODO ERGO SUM

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-04-25 : 10:28:23

I thouht we made it very clear on the other thread that you started that this site is only for SQL Server questions, not for DB2 questions.

The code you posted in not SQL Server SQL, so you are just wasting your time asking questions here (and our time).

If you are using DB2, you should post your questions on a site that answers DB2 questions.

You should try posting your questions on the DB2 forum at
http://www.dbforums.com/

CODO ERGO SUM

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-04-25 : 10:55:30

there's nothing to permit anna. but in a DB2 specific forum you're more likely to get help faster.

you are of course welcome to post general questions here.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-25 : 11:00:56

Anna,

You can, of course, post general SQL questions here. But the point is that if any of the solutions provided here uses MS-specific syntax or routines, the solution will be useless to you. A good example in this case will be IsNull() function which is MS specific function and we don't know what is the DB2 counterpart for it.

So, you can get more fast and accurate answers on DB2 specific forums rather than here.

Of course, the choice is yours.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-04-25 : 13:46:35

The problem is that you are not telling people that your code is DB2, so you are wasting the time of people here trying to figure out the non-SQL Server functions and syntax in your code.

Have you even tried posted at http://www.dbforums.com/ ? There are people there that are willing to help, and they will be people that actually know DB2.

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources