fergfamster (5/26/2016)

---

Well I gave the code at the beginning.

here is my original with 1 inline query:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[MyFunction](

@Usage_Date SmallDAteTime,

@RateCode Varchar(4)

)

RETURNS TABLE...

The problem I see is your...

fergfamster (5/26/2016)

---

Each expression used is for a reason to call a different query under each. "If statements" require declaring a variable and that errors, so was trying to find a...

DarthBurrito (5/26/2016)

---

So I have a table that contains serial numbers. However, if there's a range of serial numbers, there's only one record for that range.

For example, the table I'm working...

peter.row (5/26/2016)

---

Sean Lange (5/25/2016)

---

So you are only going to keep 180 rows out...

FunkyDexter (5/25/2016)

---

Yep, that's fully understood. My point was that...

Sean Lange (5/25/2016)

---

So you are only going to keep 180 rows out of...

FunkyDexter (5/25/2016)

---

That's correct but I like to use it anyway. It prevents...

Steve Jones - SSC Editor (5/24/2016)

---

I still think this is more complex than fixing your process. Replication is brittle, and when it fails, it's a pain to reset. I'm also...

I will ask the one question I haven't seen anyone else ask. Are you doing this on your own to reduce the 5 hour down time or has this...

Ed Wagner (5/24/2016)

---

Thanks...

paul.bowman (5/24/2016)

---

Steve Jones - SSC Editor (5/24/2016)

---

paul.bowman (5/24/2016)

---

Also sometimes what appears to be the natural primary key, from the point of view of the data model and retrieval use cases,...

Steve Jones - SSC Editor (5/24/2016)

---

Thanks, everyone.

My oldest graduated from college last year, so this is the second high school graduation for us. My middle kid has been accepted into...

Congrats Steve!

My middle daughter graduated from ERAU on May 7th, and hopefully my youngest will be graduating this weekend from High School. All depends on her final grades.

lshanahan (5/24/2016)

---

richlion2 (5/24/2016)

---

Hi,

there is one phrase I don't understand in this article:

http://www.sqlskills.com/blogs/kimberly/ever-increasing-clustering-key-the-clustered-index-debate-again/

What does this mean?

Lookup key...