question

Craig76 avatar image
Craig76 asked

Nubie Q-uestion. What do the number represent as part of the IN clause inside the case statement?

-- USING CASE STATEMENTS TO EVALUATE DATES

USE Northwind

SELECT

OrderID

, CustomerID

, OrderDate,

CASE

WHEN DATEPART(MONTH,OrderDate) IN (12,1,2)

THEN 'WINTER'

WHEN DATEPART(MONTH,OrderDate) BETWEEN 3 AND 5

THEN 'SPRING'

WHEN DATEPART(MONTH,OrderDate) BETWEEN 6 and 9

THEN 'SUMMER'

ELSE 'FALL'

END AS 'SEASON'

FROM Orders


Thank you

in
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Craig76 avatar image
Craig76 answered

This issue has been resolved.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.