Ttykuu

How could indestructible materials be used in power generation?

Am I breaking OOP practice with this architecture?

How obscure is the use of 令 in 令和?

Car headlights in a world without electricity

When handwriting 黄 (huáng; yellow) is it incorrect to have a disconnected 草 (cǎo; grass) radical on top?

Can a virus destroy the BIOS of a modern computer?

How to travel to Japan while expressing milk?

Do creatures with a speed 0ft., fly 30ft. (hover) ever touch the ground?

What are the G forces leaving Earth orbit?

How could sorcerers who are able to produce/manipulate almost all forms of energy communicate over large distances?

What exactly is ineptocracy?

Is this draw by repetition?

How to show a landlord what we have in savings?

How can a day be of 24 hours?

Implication of namely

What Exploit Are These User Agents Trying to Use?

Is it a bad idea to plug the other end of ESD strap to wall ground?

OP Amp not amplifying audio signal

Should I tell management that I intend to leave due to bad software development practices?

Salesman text me from his personal phone

How to remove border from elements in the last row?

Can I hook these wires up to find the connection to a dead outlet?

How seriously should I take size and weight limits of hand luggage?

What's the meaning of "Sollensaussagen"?

Use multiple IF condition to set variable

SQL Server stored procedure boilerplateReturning Key Values from Stored ProceduresSQL design for representing a two-level hierarchy of objects with containmentCreate variable and use in one stored procedureSelecting time metadata off a calendar tableStored procedure to describe the reason that a particular employee is unsuitable for a particular taskInsert complex object into multiple sql server tablesInner Join only if satisfies If conditionCalculate NPS in a stored procedureSQL Stored Procedure to export specified data

0

$begingroup$

I receive parameters to stored procedure:

 @BDOnly BIT
 , @CDOnly BIT
 , @PPOOnly BIT
 , @FBOMOnly BIT 

Then depending of this variables I do an IF condition to set other variables like:

 DECLARE @IsBDChecked VARCHAR(10)
 , @IsCDChecked VARCHAR(10)
 , @IsPPOChecked VARCHAR(10)
 , @IsFBOMChecked VARCHAR(10)

 IF(@BDOnly = 1)
 BEGIN
 SET @IsBDChecked = 'Test1'
 END
 IF(@CDOnly = 1)
 BEGIN
 SET @IsCDChecked = 'Test2'
 END
 IF(@PPOOnly = 1)
 BEGIN
 SET @IsPPOChecked = 'Test3'
 END
 IF(@FBOMOnly = 1)
 BEGIN
 SET @IsFBOMChecked = 'Test4'
 END

My question is, is that the best way to do this? or can I do better? Regards

sql t-sql

share|improve this question

asked 12 mins ago

JonathanJonathan

1012

$endgroup$

add a comment | 

0

$begingroup$

I receive parameters to stored procedure:

 @BDOnly BIT
 , @CDOnly BIT
 , @PPOOnly BIT
 , @FBOMOnly BIT 

Then depending of this variables I do an IF condition to set other variables like:

 DECLARE @IsBDChecked VARCHAR(10)
 , @IsCDChecked VARCHAR(10)
 , @IsPPOChecked VARCHAR(10)
 , @IsFBOMChecked VARCHAR(10)

 IF(@BDOnly = 1)
 BEGIN
 SET @IsBDChecked = 'Test1'
 END
 IF(@CDOnly = 1)
 BEGIN
 SET @IsCDChecked = 'Test2'
 END
 IF(@PPOOnly = 1)
 BEGIN
 SET @IsPPOChecked = 'Test3'
 END
 IF(@FBOMOnly = 1)
 BEGIN
 SET @IsFBOMChecked = 'Test4'
 END

My question is, is that the best way to do this? or can I do better? Regards

sql t-sql

share|improve this question

asked 12 mins ago

JonathanJonathan

1012

$endgroup$

add a comment | 

$begingroup$

I receive parameters to stored procedure:

 @BDOnly BIT
 , @CDOnly BIT
 , @PPOOnly BIT
 , @FBOMOnly BIT 

Then depending of this variables I do an IF condition to set other variables like:

 DECLARE @IsBDChecked VARCHAR(10)
 , @IsCDChecked VARCHAR(10)
 , @IsPPOChecked VARCHAR(10)
 , @IsFBOMChecked VARCHAR(10)

 IF(@BDOnly = 1)
 BEGIN
 SET @IsBDChecked = 'Test1'
 END
 IF(@CDOnly = 1)
 BEGIN
 SET @IsCDChecked = 'Test2'
 END
 IF(@PPOOnly = 1)
 BEGIN
 SET @IsPPOChecked = 'Test3'
 END
 IF(@FBOMOnly = 1)
 BEGIN
 SET @IsFBOMChecked = 'Test4'
 END

My question is, is that the best way to do this? or can I do better? Regards

sql t-sql

share|improve this question

asked 12 mins ago

JonathanJonathan

1012

$endgroup$

 @BDOnly BIT
 , @CDOnly BIT
 , @PPOOnly BIT
 , @FBOMOnly BIT 

 DECLARE @IsBDChecked VARCHAR(10)
 , @IsCDChecked VARCHAR(10)
 , @IsPPOChecked VARCHAR(10)
 , @IsFBOMChecked VARCHAR(10)

 IF(@BDOnly = 1)
 BEGIN
 SET @IsBDChecked = 'Test1'
 END
 IF(@CDOnly = 1)
 BEGIN
 SET @IsCDChecked = 'Test2'
 END
 IF(@PPOOnly = 1)
 BEGIN
 SET @IsPPOChecked = 'Test3'
 END
 IF(@FBOMOnly = 1)
 BEGIN
 SET @IsFBOMChecked = 'Test4'
 END

share|improve this question

asked 12 mins ago

JonathanJonathan

1012

share|improve this question

asked 12 mins ago

JonathanJonathan

1012

asked 12 mins ago

JonathanJonathan

1012

asked 12 mins ago

JonathanJonathan

1012