I've realized my erroring ways and fixed my problem. I believe this is the right way to do things so if not, please let me know. Here is...

The SQL works perfectly, thank you very much. Do you know how I can incorporate this in to an expression within reporting services? It will not except the...

One more question... (probably missing something very dumb here)

How can you have a result set with multiple columns if you can only group by a single column and the select...

Ah, let me take a stab at this.. (studying a bit more)

The join of the attendance and users table provides teh ability to NOT require a tmp table and is...

Jeff,

First off, thank you very much for the education on all this. There is one part of the code I don't understand / question. You are suggesting...

Jeff,

Thank you (and everyone) for all the replies. The big piece I was missing finally just sunk in. My issue was with the insert I wanted to...

Jeff,

With all due respect, I have read Ken's post about 200 times over this weekend and unfortunately, due to my lack of experience and knowledge with SQL, I have...

ALMOST there.. 🙂

Q: Is it possible to mix and match in an INSERT INTO statement?

Here's where I'm at.

select all records in the atendance table from the previous 14 days

grouped them...

Thank you...

Not sure what this has to do with my question though...

Many thanks to the previous replies (much needed)

Here is what I've done so far.

Background: I am creating a DB which will track attendance of employees via a point system....

Ug, finally figured it out.

Thanks all!

Bob

Still missing something.

In trying to use the following...

CREATE TRIGGER trgInsertNewUser

ON users

FOR INSERT

AS Insert into attendance

SELECT UID

FROM inserted

When executing this, assuming it will just create the trigger for the...

As usual, I was WAY over complicating things based on information found in the SQL books online.

Thank you VERY much!

Bob

Ok, I believe I have the idea now but am still having problems puting my code together.

I have table A which contains user ID and assoiciated point values on each...

Actually, I think I'm making way more out of this than I need to. Let me try to explain this again as I've changed things a bit.

Lets say I...