I don't know of another way to achieve the same thing, except for putting all your code in one stored procedure.  I have used this several times.  If, as I...

They have given you the correct answer.  I have always wondered why you cannot use a table variable as a parameter to a stored procedure.  This would make these scenarios much...

Please look into Merge Replication.  It is designed to do exactly what you are attempting.  It is relatively easy to setup by using Books on line.  It will gracefully handle...

I would agree with Greg on this one.  You need to see what is being passed to the SQL Server from the web page.  SQL Server does not add any...

I have no idea where a surrogate key would useful on a "glue" table like this.  The only way I would see this being useful is if you have an...

I agree that it is all to easy to fall into the trap of using the same methods for everything.  One reason I got into programming/DBA work was because of...

Okay. This one assumes you have a foreign key relationship between table A and table C enforcing that the building actually exists.

Create Procedure sp_name

(

@building_id Int,

@assessed_date datetime or smalldatetime,

@assessed_value float,...

I am not sure what you want to get into table C. A simple

Insert Into C

(

...

GO is a batch separator in SQL so it starts a second batch after the GO statement so as far as SQL Server is concerned the Create or Alter Procedure...

Are you starting a New Page after each Item Group or are you allowing Reporting Services to handle the paging? Will each item group be 1 page or less?

The...

I think 1 issue is that you need to replace the IsNull with LastYear is Nothing as IsNull is not a VB.NET function, or you could you use LastYear =...

For comparison of dates you need to use the DateDiff Function so your expression should be, I am also changing your AND to & as that is the concatenation operator...

I wish I could be of more help, than this, but, I do recall reading an article where someone did what you are trying to accomplish, so it can be...

I really enjoy working in IT, most of the time. Any job/career satisfaction is going to be affected by your work environment. When I first started in IT...

I worked for a 24x7 manufacturing operation for 7 years where I had to be part of a rotating call schedule. When I started off-hours calls were limited to...