Need the DDL (CREATE TABLE) for the table(s), sample data (in a readily consumable format), expected results based on the sample data, and your complete existing code that is failing.

Please...

If it is growing, it is because it needs to in order to store the data being inserted. Constantly growing and shrinking the mdf file is going to result...

The following sample code should get you started.

declare @ThisDate datetime;

set @ThisDate = getdate();

select dateadd(wk, datediff(wk, 0, @ThisDate) - 1, -1) -- Beginning of last week (Sunday)

select dateadd(wk, datediff(wk, 0, @ThisDate),...

purushotham.k9 (5/14/2009)

---

actuvally there are 2 reports One for all the dates, another for data just from last week. By last week I mean a previous week for any given date.

suppose...

But that may not be the "week" that the OP wants to report. That is why it is important to know what is meant by the previous week.

Please don't double post, it just fragments any responses you may get.

Please reply here.

daniel.gardiner (5/14/2009)

---

I'm not certain of the SQL functions but is it possible to:

subtract 7 days from the current date

determine the 'week' part of this date

select records with dates from this...

Doesn't answer the question. What is the previous week? Does it start on Monday, Tuesday, Sunday? Define what the previous week is. Also, take a look at...

I do agree, contact Microsoft to be sure. I, howver, read it differently. If you have dual processor system, and purchase 2 processor licenses for the server, you...

Please define what you mean by the previous week. Also, go to my blog (SQL Musings from the Desert), and you will find some common date computation formulas.

Question, why is it called "Common Sense" when it appears to be so uncommon today?

It is a scope issue. A temporary table (#TempTable) created inside of a stored procedure can be seen by other stored procedures invoked inside that stored procedure. This...

Yes, it is possible but I wouldn't do it unless it was a result of a one off process being run. If it has grown to a specific size...

I'm curious as to why you feel you need to put a new column in a specific location? The order of the columns is immaterial in SQL Server, in...

Really need more information to help you. It would help if you would take the time read and follow the guidelines in the first article I reference below in...