aleksandra 81219 (9/4/2015)

---

I cant add or reduce quotes......... Its passed from system.... im always getting '20150106','20150101', a can add sth on beginning or end, add function or sth, but...

aleksandra 81219 (9/4/2015)

---

You dont understood correctly, I can't EXECUTE procedure so modyfing it wont help

See what is underlined on my printcreen, i cant change how it is passed - im...

aleksandra 81219 (9/4/2015)

---

Hmmm so next procedure to execute first procedure? I would prefer to avoid such step because its embedded next in erp system... What is more now we have...

TomThomson (9/3/2015)

---

So for AMAZON this guy is going to use a 6 character password? And for Yahoo he'll have a 5 character password?

It...

Nice and quiet around here today. They even gave...

ChrisM@Work (9/3/2015)

---

For your amusement,...

Here is vote #3 for the DelimitedSplit8K function. You will notice there is a link to it in my signature. 😀

pietlinden (9/2/2015)

---

Interesting... Thanks Sean and Luis for the gentle "schooling". I'll have to add that to my SSC database (the stuff I brazenly steal from here... hey, gotta learn somehow!)

Maybe...

Steve Jones - SSC Editor (9/2/2015)

---

Sean Lange (9/2/2015)

---

Steve Jones - SSC Editor (9/2/2015)

---

I do agree with the = and try to use it, precisely because complex code becomes hard...

Steve Jones - SSC Editor (9/2/2015)

---

I do agree with the = and try to use it, precisely because complex code becomes hard to read when the name is buried...

Luis Cazares (9/2/2015)

---

I understand it as coder and...

I am guessing that Aaron did NOT convince Steve to use = instead of as. 😉

I have to say that I disagree with Aaron on this. I find it obtuse...

The DelimitedSplit8K is a bit overkill for this. Here is another option using PARSENAME.

select replace(parsename(replace(REPLACE(Filename, '.', ''), ':', '.'), 2), ' Records', '') as Bytes

, parsename(replace(REPLACE(Filename, '.', '^'), ':', '.'),...

Also curious what is the difference between "Development" and "Development DBA".

Sean Lange (9/1/2015)

---

Alvin Ramard (9/1/2015)

---

Sean Lange (9/1/2015)

---

Alvin Ramard (9/1/2015)

---

SQLRNNR (9/1/2015)

---

GilaMonster (9/1/2015)

---

Ed Wagner (9/1/2015)

---

ZZartin (9/1/2015)

---

Now if only all websites used the same algorithm to determine...