I am buiding a lightswitch application and it would be easiest i think to have it done right in the table if possible - is it even possible?

I appreciate the quick response. Apologies, I am new to the forum .. I will try to clarify.

CREATE TABLE #mytable(

[Campus] [nvarchar](50) NOT NULL,

[Building] [nvarchar](50) NOT NULL,

[Week] [date] NOT NULL,

[Total...