TSQL SQL Server 2008
(select case ump.SIZE_OF_FIRM
when (ump.SIZE_OF_FIRM >= 2 and ump.SIZE_OF_FIRM <= 5) then 4
when (ump.SIZE_OF_FIRM between 6 and 10) then 3
when (ump.SIZE_OF_FIRM between 11 and 25) then 2
when (ump.SIZE_OF_FIRM > 25) then 1
end) as GroupTot,
The > throws an error
The "between" throws an error
How to set a value based on a range of a variable or constant
when (ump.SIZE_OF_FIRM >= 2 and ump.SIZE_OF_FIRM <= 5) then 4
when (ump.SIZE_OF_FIRM between 6 and 10) then 3
when (ump.SIZE_OF_FIRM between 11 and 25) then 2
when (ump.SIZE_OF_FIRM > 25) then 1
end) as GroupTot,
The > throws an error
The "between" throws an error
How to set a value based on a range of a variable or constant
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's what were here for. Good luck with your project. -Jimbo
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for Jeff_Kingston's comment #a39528564
for the following reason:
How many times do I have to do this?
Accepted answer: 0 points for Jeff_Kingston's comment #a39528564
for the following reason:
How many times do I have to do this?
Assuming that my first comment answered your question, you need to click on 'Accept as solution' on that comment, which will end the question.
ASKER
Saved my Friday from becoming Saturday