SQL Table query

[atuljadhavnetafim]

Dear Expert

i have one table "AR" in SQL Server, and in that table one column is there named "Arrear"
this column contain positive and negative numner like
123, 43, 54, 0, -34, -56, -678
now i want to bifurcate this number in category like
if the bumber >=0 then category will be "OD"
if the number <0 then category will be "FD"
i have one blank extra column in my data base, or we can create new column with above condition

but how

please help me

 

[FormR]

You can use a CASE WHEN expression:

CASE (Transact-SQL)

Not tested, but for example:

SELECT Arrear, CASE WHEN Arrear >= 0 THEN 'OD' ELSE 'FD' END AS 'CATEGORY' FROM AR

 

[atuljadhavnetafim]

You can use a CASE WHEN expression:

CASE (Transact-SQL)

Not tested, but for example:

SELECT Arrear, CASE WHEN Arrear >= 0 THEN 'OD' ELSE 'FD' END AS 'CATEGORY' FROM AR

but where i use this code, and CATEGORY column will update automatic or not.

 

[FormR]

This allows you to assign the category on the fly, if you want to store the value in the database then I imagine that you would need to amend the process that writes the records to that table.

 

[atuljadhavnetafim]

This allows you to assign the category on the fly, if you want to store the value in the database then I imagine that you would need to amend the process that writes the records to that table.

i give u broad picture

i have 6 table in SQL Server, all table are linked with each other with different criteria
then i created one View which give me single table with all the selected category from all 6 tables, and that view table linked with my excel as pivot table

but i am not able to give formulas which i used to give in excel, i also can give above condition in excel but i want this shuould be happed in AR table itself, i have one etxra column with name "OD_FD" in AR table but it is NULL write now, i want result in same table in "OD_FD" column,

and if it is not possible then it should be done in my View table

i hope now i am clear

 

[FormR]

You should be able to use the CASE construct in your view table to assign the category.

 

[atuljadhavnetafim]

You should be able to use the CASE construct in your view table to assign the category.

thanks for ur reply but i am not expert in SQL

will u please give me steps, will help me lot

after that i have another formula to incorporate this

and second thing, how much row will sql support ?

 

[FormR]

thanks for ur reply but i am not expert in SQL

will u please give me steps, will help me lot

You may be better then to post this question to an SQL forum.

and second thing, how much row will sql support ?

More than Excel

 

[atuljadhavnetafim]

You may be better then to post this question to an SQL forum.



More than Excel

if any body can help in this regards
thansk in advance

i also asked this at sql forum not no reply till time

 

[FormR]

What part are you not clear about? Can you post the SQL you used to create the view?