SQL Kiwi (9/23/2012)
Lynn Pettis (9/23/2012)
Once again, you post code that won't even parse. Your CREATE TABLE isn't valid:All that is missing in a final close-parenthesis for the CREATE TABLE.
True. The problem is that I haven't been able to directly use any of the code Mr. Celko has posted recently because it doesn't parse. He is supposed to be a SQL guru and he posts code like many of the OPs seeking help. I have posted code that had errors at times, and when I found out or was informed of the issue I have gone back to correct my code. Mr. Celko doesn't even do that.