Trudye, I tried to give you a hint that you were casting the result. This will work with your current column which is in numeric format. ...

😛

Hey Trudye:

You need to think about this a little. Your [CEFDT] is NOT really a date. It is a numeric column holding a bunch of numbers...

America learned, Jeff.

Lynn we are all grateful to your daughter and all those like her for their service and sacrifice. God bless her and keep...

Trying to use case statements to return different datatypes will fail in some cases (like mixing character data with numeric. ) Why you would want to is beyond me...

You're almost there...

SELECT z.ZipCode, z.CountyName,

MAX(CASE WHEN productid = 1 THEN customerid end) AS 'product1',

MAX(CASE WHEN productid = 2 THEN customerid end)...

No need to cast everything as float. This will work too.

select 1.0*1/100

-- but not

select 1/100*1.00

SQL resolves each step of a calculation and returns the result using the more...

I don't know, Jeff. After seeing the kindler/gentler you in action in that "urgent" thread that the OP never came back to, I'd say it's time for...

Ohhhh..... you mean real physical objects... not higher level code constructs. 😉

I got the term from early William Gibson: Neuromancer / Count Zero, but Gus got it right with his link.

Did anyone here ever play a card game called...

The volcanic super-eruption of Yellowstone should shatter and melt a lot of the glacial ice, although the ash from the blast will probably bring on global cooling as well as...

Black Ice

Jeff,

I have a couple of questions:

(1) Who are you, and (2) what have you done with Jeff Moden?

Alternatively:

(1) What kind of tranquilizers are you taking?

(2) Do...

I was going to do a version with a CTE, but it wouldn't have been substantively different from your solution, Ken.

Hey Elliot... what kind of cookies?