If statments in MSSQL

[Normann]

I’m am trying to create a StoredProc that will, if a value is below a limit it will insert one value or if the value is above a limit then it will insert another value. Sort of like this in C programming:

            if (ValueOriginal >= 3)
            {
                if (ValueOriginal <= 10)
                    ValueToInsert = ValueOriginal;
                else
                    ValueToInsert = 0;
            }
            else
                ValueToInsert = 0;

Hope Someone can help me

NormanTheDane

[prileep]

I’m am trying to create a StoredProc that will, if a value is below a limit it will insert one value or if the value is above a limit then it will insert another value. Sort of like this in C programming:

            if (ValueOriginal >= 3)
            {
                if (ValueOriginal <= 10)
                    ValueToInsert = ValueOriginal;
                else
                    ValueToInsert = 0;
            }
            else
                ValueToInsert = 0;

Hope Someone can help me

NormanTheDane

If u just want to know how to use IF state ment in SQL Server,

Format one:
IF <condition> <then code to be executed when condition true>
Format two:
IF <condition>
BEGIN
<then code to be executed when condition true>
END
ELSE
BEGIN
< else code to be executed when condition is false>
END

[almaz]

insert <<YourTableName>> (<<ListOfFields>>) values 
(case 
    when @ValueOriginal >= 3 and @ValueOriginal <= 10 then @ValueOriginal 
    else 0 
end, <<OtherFields>>)

[hariharanmca]

I’m am trying to create a StoredProc that will, if a value is below a limit it will insert one value or if the value is above a limit then it will insert another value. Sort of like this in C programming:

            if (ValueOriginal >= 3)
            {
                if (ValueOriginal <= 10)
                    ValueToInsert = ValueOriginal;
                else
                    ValueToInsert = 0;
            }
            else
                ValueToInsert = 0;

Hope Someone can help me

NormanTheDane

  if  ValueOriginal >= 3
            Begin
                if  ValueOriginal <= 10 
                    ValueToInsert = ValueOriginal
                else
                    ValueToInsert = 0
            end
            else
                ValueToInsert = 0

Try This

[Normann]

Thanks for all your help, I have it working now.