Vwwxrf

How to show a landlord what we have in savings?

Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?

What is the fastest integer factorization to break RSA?

Is it possible to create a QR code using text?

Sums of two squares in arithmetic progressions

Were days ever written as ordinal numbers when writing day-month-year?

How does a dynamic QR code work?

In the UK, is it possible to get a referendum by a court decision?

Can compressed videos be decoded back to their uncompresed original format?

Can a virus destroy the BIOS of a modern computer?

Does int main() need a declaration on C++?

What historical events would have to change in order to make 19th century "steampunk" technology possible?

Machine learning testing data

Why was the shrink from 8″ made only to 5.25″ and not smaller (4″ or less)

GFCI outlets - can they be repaired? Are they really needed at the end of a circuit?

Could neural networks be considered metaheuristics?

How dangerous is XSS

Could the museum Saturn V's be refitted for one more flight?

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

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

Unlock My Phone! February 2018

Forgetting the musical notes while performing in concert

Why are UK visa biometrics appointments suspended at USCIS Application Support Centers?

What does the same-ish mean?

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 13 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 13 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 13 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 13 mins ago

JonathanJonathan

1012

share|improve this question

asked 13 mins ago

JonathanJonathan

1012

asked 13 mins ago

JonathanJonathan

1012

asked 13 mins ago

JonathanJonathan

1012