Query Statement - SQL 2000

Question

Post reply

Query Statement - SQL 2000

ridzuan_first

Right there with Babe

Points: 798
More actions
September 27, 2009 at 8:43 pm

#72991

Pls anyone help me ...
I need to pull the record from one fileld in the table that contains positif and negative value.How to write query statement to separate data for both - and + value
Your help apprieciated.
Dwen

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 1

For better answers quicker, I recommend the following article...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)