stricknyn (6/10/2016)

---

Hi Drew,

Thanks for your response. Unfortunately no. The other process is designed that way because there are other processes (much like this stored procedure) that will be...

No, but you can pass a table variable into a stored procedure. Can you modify the other process to create a table variable rather than a temp table?

Drew

Jeff Moden (6/9/2016)

---

drew.allen (6/9/2016)

---

Jeff Moden (6/6/2016)

---

And notice that Drew did NOT suggest using 9999-12-31. That's because the classic method of isolating date ranges requires a "AND SomeDTColumn < @EndDate...

Jeff Moden (6/6/2016)

---

And notice that Drew did NOT suggest using 9999-12-31. That's because the classic method of isolating date ranges requires a "AND SomeDTColumn < @EndDate +1" and all...

This actually might perform better, but it requires that the earliest balance not be NULL, which is not true of your sample data.

SELECT b.*,

FIRST_VALUE(m.Balance) OVER(...

etl2016 (6/9/2016)

---

Dear All,

We use ROW_NUMBER () to partition results and hand-pick the needed records, mostly to address duplicate records scenario.

However, how do we sense that there is a potential threat...

simon.barnes (6/8/2016)

---

a) both the things DouglasH said

b) you mentioned they were heaps and now have indexes; but do they now have clustered indexes? If not then they're still heaps. This...

It looks like the piece you might be missing is a calendar table to make sure that you have all of the dates instead of just the dates where there...

There's actually a third problem, but I don't want to say what it is, because the OP needs to understand how this query...

There is no need for dynamic SQL here. He's storing these values in a temporary table, and the values aren't going to change (in most cases) between when he...

erouse (6/8/2016)

---

Thanks for your reply Drew but the quotes aren't stored in the tables. If we run SELECT * from #mydaterangetable WHERE tbldaterangeID =3 we get:

3Last 7 daysDATEADD(day,...

That because you have your "date expressions" enclosed in quotes when inserting into the temporary table. The are never evaluated, so they never produce dates.

Drew

marcossuriel (6/8/2016)

---

Hello Drew,

I did look at the results I'm getting over and over and I'm trying to understand what the ROW_NUMBER() is doing, but I'm a little lost. I see...

marcossuriel (6/7/2016)

---

Hello Jacob,

I have the results I want from the dataset provide, but not sure how to show them in table view on here.

lotnoitemnodescwarehousecurrentqtycosttransdatetranstypetransqty

005965001TEQU0110 ...