Point is:

The quiz as it's done allows ambiguity.

For value "15" there are 3 answers, each of them is right.

And Andrew is the only one who caught it.

Everyone else sucks.

P.S. You're...

Try to run the code.

Yes, it's quite obvious that only one case should be applied.

But which one?

Computer does not do any implications.

Unless you specify the rules for it.

Andrew demonstrated the very computer-like way of...

And result for 15 will be ...

drrrrrrums....

'BIZZ' !!!

Poor logic!

Did you suggest CASE?

Case will pick 1st match, it will never come to the last one.

> The answer to your question, IMHO, really...

Agree.

But replace with what?

'Bizz', 'Buzz' or 'BizzBuzz'?

All three options are valid!

I like this logic!

Logic is as poor as logic of original quiz.

What was asked?

"each number evenly divisible by 3, substitute 'Bizz' For each number evenly divisible by 5, substitute 'Buzz'...

Or you can set IDENTITY_INSERT ON and manually insert a row with ID = 32999.

Don't forget to set IDENTITY_INSERT back OFF and delete that...

DBCC CHECKIDENT

Join result of rubes's query to Table2 on (ID + LogDate) and get desired result.

Depends on performance of your hard drives.

It needs to allocate 200GB.

So, it will take some time.

For text datatype you need to use PATHINDEX instead of CHARINDEX and SUBSTRING instead of LEFT.

Check Books Online for the syntax.

CASE goes right after SELECT.

John,

to avoid errors when pattern cannot be found in string use this:

CASE WHEN CHARINDEX('substring', Value) = 0

THEN Value

ELSE LEFT(Value,CHARINDEX('substring', Value)-1)

END

Kenneth,

forgive those who don't have anything to say but love to show up anyway.

> I also know that you know what I mean,...

Try this:

....

FROM employee E

LEFT JOIN vw_Attendance_Report hj ON E.Empcode = hj.Empcode

RIGHT JOIN cms_date kj on kj.day_month =datepart(dd,FirstAccessDateTime)

order by E.empcode , kj.day_month