Help with T-SQL (2008R2)

Question

Help with T-SQL (2008R2)

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101207 More actions · Answer 1

CASE WHEN ALTotalUnits / TotalProfiledHours >= 3 THEN <higher than 3 weeks>
CASE WHEN ALTotalUnits / TotalProfiledHours < 3 THEN <lower than 3 weeks>

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Jay@Work SSCrazy Points: 2633 More actions · Answer 2

How can I output the actual values under the column headings as shown below?

ScottPletcher SSC Guru Points: 101207 More actions · Answer 3

If you want blanks rather than NULL, then:

CASE WHEN ALTotalUnits / TotalProfiledHours >= 3 THEN CAST(ALTotalUnits AS varchar(30)) ELSE '' END AS [Higher than 3 Weeks],
CASE WHEN ALTotalUnits / TotalProfiledHours < 3 THEN '' ELSE CAST(ALTotalUnits AS varchar(30)) END AS [Lower than 3 Weeks]

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".