SwePeso (4/28/2010)

---

Here are two problems?

The original and the "Excel column numbering" question?

For the original question, to keep the result within VARCHAR(8000) the maximum line number to convert is 208000...

For one horrible heart-stopping moment, I thought that was your solution to the 'more interesting' problem!

I really wouldn't put it past you to...

You are right - this is a much more interesting problem! I haven't checked the link you posted yet, because I wanted...

Scope Resolution Operator (Transact-SQL)

Another example of its use is with GRANT, REVOKE, and DENY:

GRANT (Transact-SQL)

Lynn Pettis (4/27/2010)

---

It is based on the 0.0 in the comparision. If you change it to 0.00 it becomes numeric(2,2). Adding a second 0 before the decimal (00.00)...

It's all about different logical processes. Often,...

Thanks!

Yep. I'd only start to worry if you start finding SSC notification emails stashed around the house in unlikely places.

Adam Machanic (4/27/2010)

---

I'm going to unsubscribe right after I read the next post after this one. Or maybe just a couple more after that. We'll see, but definitely sometime in...

:laugh: Sounds all too familiar :laugh:

TheSQLGuru (4/27/2010)

---

Jeff, didn't they completely remove support for "SELECT 1 FROM E01 a, E01 b" in SQL 2008 or 2008R2? I thought that non-ANSI stuff was going away. ...

On string splitting and performance:

There was a *huge* thread on this last year on SSC. Florian Reischl was good enough to post a very comprehensive set of results on...

Grant Fritchey (4/27/2010)

---

That's not even in the top 10. It's almost, almost, straight forward compared to some of the insanity I've seen at my company. No temp tables or table...

Absolutely right!

nfs_john (4/27/2010)

---

I agree an assembly would be the best approach. Why recreate the wheel and an assembly would be more globally universal for others to make use of as well....