KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
What I'm trying to do is use more than one CASE WHEN condition for the same column. Here is my code for the query: SELECT Url='', p.ArtNo, p.[Description], p.Specification, CASE WHEN 1 = 1 or 1 = 1 THEN 1 ELSE 0 END as Qty, p.NetPrice, [Status] = 0 FROM Product p (NOLOCK) However, what I want to do is use more then one WHEN for the same column "qty". As in the following code: IF // CODE ELSE IF // CODE ELSE IF // CODE ELSE // CODE
Tags (comma-separated)
Save Edits
Cancel