Disclaimer: I do NOT work for Redgate

Your easiest bet might be to invest in SQL dependency checker (yes - it's from RedGate, the parent company for this very site). ...

You'd probably want to look at a splitter process. You'd bring the entire line in as a single variable , inspect the 4 characts, and use a conditional split...

This is not unlike some of the techniques used a few years years back to phyisically segment networks, and not let internal nodes see each other. Another one like...

Jeff Moden (4/22/2015)

---

Matt Miller (#4) (4/22/2015)

---

Jeff Moden (4/22/2015)

---

grant-665832 (4/22/2015)

---

I'd do this in a C# CLR. Or in a simple program to generate the sequence and write it to DB...

Jeff Moden (4/22/2015)

---

Why?...

Jeff Moden (4/14/2015)

---

Enumerate each value with ROW_NUMBER() and do a +1 offset self join. Then look for where the "lo" value is greater than the "hi" value (the +1...

John Mitchell-245523 (4/10/2015)

---

No, it's not as simple as that, and the more you look at it, the more complications you'll see. What about tabs, carriage returns, schema names, comments...

Assuming you did you could end up with something like this to combine your last order with your average order days:

With ordersCTE as (

SELECT ROW_NUMBER() OVER (

PARTITION...

Kat - you probably want to look at Dwain's answer just above. You really do NOT need to calculate the # of days between EACH order (as you are...

Yet Another DBA (4/2/2015)

---

Gary Varga (4/2/2015)

---

I believe that the best future lies ahead for those that create variously grained sets of SOA services. Going all out with current standard (my...

It's the nature of the data types you're using. Float point or "approximate" data types handle values differently than "precise" data types.

The fact that one example happens to store...

jshahan (3/30/2015)

---

Luis Cazares (3/30/2015)

---

I would think of Ozzy Osbourne. They're both precursors on their genres (SQL & heavy metal) and they appear to be more frightening than they really are....

GoofyGuy (3/30/2015)

---

I ran across a review of a developer's first year at a company. The company is endjin and the poster describes their first year as a "software engineer apprentice,"...

Depending on what's feasible:

1. considering just restoring the product DB holding that table into your test environment, extract the data...

Initial Suggestions:

1.don't do it that way at all.

2. certainly don't take the advice of ANYONE on the net and run it on your prod environment without testing it...