I have experienced similar results when creating a new database.  I believe nothing is visible until at least one user object is available.  Just so you know you are not...

An easier way is to set the @DateFirst to show day 1 as Monday.  Do this with:

set datefirst 1

Research the use of triggers on the table to track the changes or put the audit trail within the stored procedures used to update the tables.  If users can directly...

To my knowledge, stored Procedures are compiled every time you alter and run the SQL of the procedure.  What is your concern or doubt?

Use the Datediff function:

Current Week: DateDiff(wk,datefield,getdate()) = 0

Previous Week: DateDiff(wk,datefield,getdate()) = 1

Current Month: DateDiff(mm,datefield,getdate()) = 0

Previous Month: DateDiff(mm,datefield,getdate()) = 1

I'm not sure I'm following your question.  Can you post a few rows and show the select statement? 

From Books On Line:

@@ERROR is the only part of a Microsoft® SQL Server™ 2000 error available within the batch, stored procedure, or trigger that generated the error. All other parts...

Sivakumar,

I don't see where you are using the sp_executesql.  The cursor declaration needs to be part of the @SQL string.  But what are you trying to achieve?  It would appear...

Mark is correct you could have two separate SQL statements within the proc, however beware of the execution plans.  It will be saved with the first performance and whatever table...

That is why if find the use of table aliases critical to readability and debugging of SQL statements.  In case you haven't used them your SQL could change to:

SELECT     t1.field1,...

Regardless of how you do it you won't get out of the query building process, however you can get out of it with some programming.  Our internal OMS was written...

True, but the they (Microsoft and the company creating the charting tool) are working on enhancements for this year.  Also remember this is a 1.0 product.  I'm sure it will...

I've just displayed the data below the chart in a table or matrix like a standard report.

My suggestion then is to add tblSite to the view in question and see what the execution plan is.  You may also want to make it a stored procedure that...

Why are you using an subquery?

select CASE WHEN Invoice_FK IS NOT NULL THEN 'Invoice ' + ' Invoice_ID:' + CONVERT(VARCHAR,INvoice_fk) END

  , Amount as Amount

  , st.add_datetime as...