"and, sorry, I almost forgot... there aren't any "fields" in a database, they're called "colums"" 😉

If it were me in the interview and I was asked that question about that query,...

I'm anal about formatting and embedded documentation. I imposed rigid formatting requirements on all the developers in the form of publicised SQL Standards. Everyone knows what I expect...

Perfect. Thanks Dan... you won't spend the time in vain.

Actually, you hit the nail on the head, Steve... there should be a database for utilitlity functions of this nature. I suggest the name of UTILITY? 😉

I'm cynical as well... but the very thought of making a database engine that truly responds to the columnar nature of an RDBMS is thought provoking and intriging, at the...

Heh... or maybe, Jeff? 😀

Don't sell yourself short, Lynn... your a humble man that knows more than you think. Sounds wierd, but maintain the humility with pride. I would honor the chance...

GF (3/2/2008)

---

Hi all,

this topic is almost what I am in need of. I have looked at Jeff's Code and I see the potential but I am a bit confused as...

noeld (3/10/2006)

---

For some things, you don't need the tally table

SELECT SentenceID,

datalength(Left(' '+y.Sentence+' ', N)) - datalength(replace(Left(' '+y.Sentence+' ', N), ' ', ''))InSentenceNo,

SUBSTRING(' '+y.Sentence+' ',N+1,CHARINDEX('...

Carl E. Campbell (3/10/2006)

---

I'm starting to get the hang of using these tally tables, but I'm a little foggy on the sequence of events (my experience up 'till now is...

Take a look at the URL in my signature line... it'll show you how to post some data so we can play with the same data as you...

The problem is, that YOU don't own Master... Microsoft does. They can put or remove anything they like, including code that doesn't belong to them, during any service pack...

You need to double up on the embedded single quotes...

xp_cmdshell 'bcp "select CUSTOMER_ID,Email1 from R4W_001.dbo.SYSCUST_AUDIT where Email1=''abc@sarasu.com''" queryout "C:\SoundPub\EmailList\durga2.csv" -T -c'

Heh... considering that it's been over two weeks, I guess you do mind.

Thanks, anyway 😉