just join table...

By trebuchet or air cannon?

Who said it was a bug? 😉

Try this. As pointed out earlier, you could also generate this as dynamic SQL with a MAX() line for every distinct attribute description. This assumes that...

Grammar lessons you need. Help you I cannot. Yes!

No argument here. I've already cut and pasted them into my snippets library.

Most of our output goes to either reporting services, spreadsheets, or user interfaces that handle the formatting. The only raw SQL reports are ad-hoc. ...

No reason at all 🙂

Good plan. Psychological issues are better served by counseling 😉

The mighty Garadin is correct. My last couple of examples were step-by-step, each dependent on the last. You can of course nest the steps into...

Take a look at the UNPIVOT operation. Unfortunately, you will have to list all columns by name.

http://msdn.microsoft.com/en-us/library/ms177410.aspx

Sergiy's right. STR is often a better choice, but it depends on what you're going to do with your output.

If you're going to use STR, be sure...

Ned,

It is good of you to post up solutions which might be useful to others.

To elaborate on what Sergiy said, because datetime format is numeric...

CAST or CONVERT the decimal amount to varchar and then you can use an empty string with ISNULL.

select isnull(convert(varchar(10),amount),'') as amount

Just in case your question isn't about the format of the INSERT statement, but rather about how to designate your columns in the ACCESS database...

If your question is how...