gmamata7 (10/5/2011)

---

Thank you..It somewhat cleared my confusion.

But to be specific, we followed the below link to configure FileStream RBS for Share point databases.

In this case, does native sql server backup...

I know this is just a geeky thing....

HTH.

You ahd 2 begins one after another. The 2nd one needed to be after the if.

Then you were missing and parenthesis after the last...

Depending on wether you need more columns from the historical table you do one of these.

SELECT * FROM (

Select *, ROW_NUMBER() OVER (PARTITION BY Order, Date ORDER BY Date DESC)...

CREATE PROCEDURE em_oeHistory1 @working_date CHAR(8)

AS

BEGIN

If ( @working_date <= '' )

...

GilaMonster (10/5/2011)

---

You get a difference because the query adds the milliseconds since the server started to the time that SQL started. So if SQL Server started 27 seconds after the...

What do you need to do overall? My first impression is that you may be overthinking this...

Cool.

Just a fyi. For big displays like this I find it easier to nullify all the 0s (unless they mean something, even if it's just 2 operations that cancel...

Please post your new code and the error you get.

The case needs to come earlier in the syntax... this works in my prod server :

, SUM(Quantity) AS QuantityAll

...

So you want everthing before september 5th or evertything after that?

You might as well start with the best way to do it...

http://sqlfool.com/2011/06/index-defrag-script-v4-1

I'm asking what you gave to him so that I can fill in the blanks or edit an analogy.

I'm notlooking to spend 3 weeks writing a full book to re-explain...

What did you say to him?

Jeff Moden (10/5/2011)

---

Ninja's_RGR'us (10/5/2011)

---

Jeff Moden (10/4/2011)

---

GilaMonster (10/4/2011)

---

I don't. If...