Re-Regard. It's still arguing the same point after removing the second half of FROM

Disregard. Found it:

FROM BoatingWarning BoatingWarning

I'm having the same issue with the following query. Is there anything evident within it which woudl be causing:

"Msg 512, Level 16, State 1, Line 2

Subquery returned more...

Thank you for that advice, but it's not my job to format the xml. It is just my job to create the view and have it output to xml....

Thank you. It's just been a long day and i'm frazzled. The full query (as much of it as i have now) is posted below. The...

i will admit, now i'm feeling completely lost in the weeds and twisted around nine ways to sunday on this. My brain has been frazzled by this all...

Thank you. I've kind of had the sense that this is where i should be heading with this. Please pardon my confusion, but wouldn't i be using a...

All set on this end. Thanks to all.

That project is now closed and waiting for internal review. On to the next.

I like the non CE option better. The select statement fires off fine, but what do i need to change to make it actually update those receiptno's?

Thanks.

Again, the fruits of me starting my day by rushing into something without first having had a gallon of coffee and clearing the cobwebs.

Bingo. Ugh. Thanks.

what about transaction logs? is the use of the import wizard not logged by SQL as opposed to the execution of that query?

For myself, this is a career change. I've stepped out of the medical field, as both a medical provider, CEO, and IT specialist for the clinics i owned,...

Cool. Thanks.

i think i'll start using this site as opposed to "the other one".

thanks again.

However, one more issue with these tables. I know need to update part of a string that i placed in several different columns in the Subjects table. ...