sqldba_newbie (4/9/2013)

---

Lynn Pettis (4/9/2013)

---

To really help, read the second article I reference below in my signature block regarding asking for help on performance issues. Follow the instructions in that...

To really help, read the second article I reference below in my signature block regarding asking for help on performance issues. Follow the instructions in that article on what...

And why do you say that?? 😉

Sean Lange (4/9/2013)

---

PSB (4/9/2013)

---

Ye s we will need to consider location,Site and Code while eliminatong

I want to eliminate PrevTrans 1,2,9 because for the same site,location and code because PrevTrans 2...

And the OP has left without proviing any more information or feedback.

And then, are you really talking about the calendar week or the ISO Week?

This?

declare @TestData table(

NextYear int,

CustId int,

Customer varchar(5),

ScheduledDate date,

ActualDate date,

...

Yea, don't think my code works quite right. Use a calendar table like previously suggested.

Okay, now I am totally lost. Given a specific date (getdate() in this case), return the week...

mickyT (4/9/2013)

---

I may be barking up the wrong tree with this, but are you after

SELECT SUM(quantity)

FROM sale s

WHERE EXISTS (SELECT 1 FROM eval e WHERE s.email = e.email)

...

This help?

SELECT

DATEPART(WEEK, DATEADD(MONTH, +3, getdate())),

dateadd(week,datediff(week,0,getdate()),5),

DATEADD(MONTH, +3, dateadd(week,datediff(week,0,getdate()),5));

And just...

Why the join to eval?

Do the following in an empty (sandbox) database:

create table dbo.sale (email varchar(255), quantity int);

insert into dbo.sale values ('email1', 1);

insert into dbo.sale values ('email2', 2);

insert into dbo.sale...

Also, if you are adding and deleting data, you really should create a clustered index on the table. As a heap it will just continue to grow and not...

Based on the following:

create table playground.sale (email varchar(255), quantity int);

insert into sale values ('email1', 1);

insert into sale values ('email2', 2);

insert into sale values ('email3', 3);

insert into sale values ('email4', 4);

create...