Can I Use Conditional Statement In Variable Declaration?

Question

1.00/5 (1 vote)

See more:

C#

I have Created a Portal in which when user enter some ID.then many columns associated for that ID shows up. Now i want that if user enter some specific IDs then values of some columns(NASSETS,Depreciation key)associated with That IDs should be fixed.

I want Nasset to be blank for some Asset Classes.I want depriciation key as 0000 for some Asset Classes.

Can I use "If Statement" in declarion of variable.

I have this stored procedure for that work.

JavaScript

SELECT FA.Asset_Class AS 'Asset Class',
           '1000' AS 'Company Code',
           '1' AS 'NASSETS',
           U.Asset_Desc AS 'Name',
           U.Asset_Desc+' ('+ U.Material_Code +')' AS 'Asset main no. text',
           UOM.Base_UOM AS 'Base Unit of Measure',
           'X' AS 'XHIST',
           'X' AS 'Include asset',
           '' AS 'Asset capitalization date',
           P.Plant_Name AS 'Business Area',
           C.CostCenter AS 'Cost Center',
           P.Plant_Name AS 'Plant',
           FA.IO_No AS 'Order',

           '01' AS 'Real depreciation area',
           'R999' AS 'Depreciation key',
           '' AS 'Planned useful life in years',
           '' AS 'Planned useful life in periods',
           '20' AS 'Real depreciation area',
           'R999' AS 'Depreciation key',
           '' AS 'Planned useful life in years',
           '' AS 'Planned useful life in periods',

           '4' AS 'AFASL_01',
           '4' AS 'AFASL_02'

Posted 22-Dec-15 18:02pm

Laviee

Updated 22-Dec-15 18:03pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2015-12-22T23:08:00

It's not entirely clear what you mean but I'm fairly sure you want the CASE (Transact-SQL)[^] statement.

For example, using some test data generated by

SQL

-- Some test data
Create Table Table1
(
	id int identity(1,1),
	someTextData AS 'Data' + Cast(id as varchar),
	someDateData AS DATEADD(dd, id, CAST('2000-01-01' as Date))
)
go
insert into Table1 default values
go 100

You can adjust the results of the query thus

SQL

select 
	id, someTextData, someDateData, 

	CASE WHEN MONTH(someDateData) = 1 THEN 'January Sales' 
             ELSE someTextData 
        END as contrived

from Table1

On the other hand, if you mean that you have a variable declared and want to adjust it's value, you can still use the CASE statement

declare @AVariable INT = (select count(*) from Table1)
declare @AnotherVariable INT = CASE WHEN @AVariable > 50 then 1 else 0 end
select @AnotherVariable

If you are planning to do something a little more complex - e.g. multiple statements would depend on the condition then use the IF...ELSE (Transact-SQL)[^] statement
e.g.

IF @Avariable > 100 
BEGIN
	SET @AnotherVariable = 200
        --  ... do some other stuff
END
ELSE
BEGIN
	SET @AnotherVariable = 100
        --  ... do some other stuff
END 
select @AnotherVariable