I have a message table that acts like internal email; a user can send another user a message. I have a case where I want to send all users the same message, so say I have 10 users, I want to insert 10 messages into the message table identical except for the 'To' field, which should be each users unique 'Id'.
So for a message to a single recipient I would have:
INSERT INTO Messages To=@To, [From]=@From, Subject=@Subject, Message=@Message
I can't even get started on this, I know I need to SELECT Id FROM Users, then use this in the original query...
INSERT INTO Messages To=( SELECT Id FROM Users ), [From]=@From, Subject=@Subject, Message=@Message