So this will work:

declare @ThisDate datetime;

set @ThisDate = getdate();

with ThreeWeek as (select rn...

And to get you started, here is what I would do on the fly:

declare @ThisDate datetime;

set @ThisDate = getdate();

with ThreeWeek as (select rn from (values (0),(1),(2))dt(rn))

select dateadd(wk, datediff(wk, 0,...

sharonsql2013 (5/4/2015)

---

I am trying to get Start date for this week and the coming 3 weeks.

For this week this is what I have come up with :

Select DATEADD(dd, -(DATEPART(dw, '2015-05-06...

Luis Cazares (5/4/2015)

---

Lowell (5/4/2015)

---

your sample data didn't have any duplicates; since this seems a little homework-like, i'll give you just a couple of hints.

duplicates are typically removed by using a...

You have two choices. One, license the physical hardware on which your VM run. Two, license the VM on which SQL Server will run. Using Standard Edition,...

Jack Corbett (5/4/2015)

---

Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something...

It really comes down to "it depends." Can't say either is right or wrong.

Or create a new column with ne collation, move the data from the old column to the new column, drop the old column, rename the new column to the old...

I have to agree as well. I have almost 20 years experience and I know that I don't know everything. I still have a lot more learn as...

I see it as creating flexibility regarding the database. Some databases may always be small, but for those that become large, being able to move things around to new...

djackson 22568 (5/4/2015)

---

RonKyle (5/4/2015)

---

It's not just the defaults. Almost every database I come across has a single PRIMARY file. I always separate the system tables out like so:

Changing...

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix this poorly...

Eirikur Eiriksson (5/3/2015)

---

SQL-DBA-01 (4/30/2015)

---

HI Experts,

Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?

use [AdventureWorks_2005]

SELECT * FROM dbo.sysFILES

OR

SELECT ...

Jeff Moden (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix...

Sorry I didn't get to this sooner, but here is an untested shot of what you need.

I am posting it as an attachment as I seem to be having issues...