Since my late teens and up until now I was always able to articulate a simple core philosophy that I could live by but those didn’t include my mortality (probably...

Thunderous silence... 🙂

This forum clearly wasn't the place to attempt to initiate this kind of philosophical discussion. My bad.

Thanks, Paul. I re-read the Extra Credit section of part II (great job by the way and thank you) and your last response and believe I can paraphrase it...

Thanks for the validation, Craig.:-) I read both parts one and two...

Thank you for the quick response, Craig and I’m also a fan of your posts. I’m with you on the need for the identity column but some of the...

Cadavre

I want to tell you how much I admire your solution to this post.

When I code, I pose questions to myself and answer them with my SQL. I pretty...

By all means, consider starting (or even an entire career) as a SQL Developer. SQL is easy to learn (it’s practically English) and in one form or another behind...

I think there is substance in the earlier post about musicians having an apptitude for IT and vice versa. Maybe the primary attribute is that to be good at either...

I was going to point out that you could only choose among the available responses and ‘Impossible” is the best answer. But since you are able to discern what...

Fine. Show me code that will update Col1 in a table that where that column doesn't exist and I'll agree with you.

Impossible is absolutely the correct answer. Col1 does not exist and cannot be updated.

Maybe someone sugested this and I missed it but just convert getdate() to a string and back to a date.

select CONVERT(datetime,(convert(char(10),getdate(),101))) as Today

I'm appreciative of the exposure to T-SQL functionality and applications that I rarely use (in this case OVER and CTEs). This is clear and well thought through. ...

You could also try a comma delimited export and import the results to excel.

It's been a few years since I've had to work with Access but I don't miss it much. There were several shortcomings such as 1) Trying to do complex...