r.hensbergen (12/11/2008)

---

Tip: add next...

It's nice to see some documented code for a change. Thanks. 🙂

I think you've made things just a little difficult on yourself and I think I can help,...

Try adding the -n parameter to the OSQL cmd line.

Heh... well, someone had to answer it! 😛

BWAA-HAAA!!! Sorry for the previous dumb question folks... didn't realize it would be this easy. Thought I'd share my results... of course, the email and IP addresses have...

Ian Ritchie (12/1/2008)

---

I have a function which I use to split the address on a few databases (It is separated by a carriage return, so just amend the code to...

Actually, if you do a search for "Numbers Table", you'll find all manner of methods to make such a "tableless" number generator. I don't use them... I use an...

Basically, it's nothing more than a bunch of "derived tables"...

Crud... nah... I missed that... I was just flying through some posts and didn't look....

rite2shubhra (12/10/2008)

---

I want to Exclude the two columns from the Group By clause of the following query, If I don't include them its giving me error that "Column 'T4.ORG_NAME' is...

Zeev Kazhdan (12/11/2008)

---

Because

All I want to put City and State information in front of Project

means for me that all the calculations should be done for the group of those...

Sure... got any links? 😉 And, how do they apply for this particular problem?

Nope... no style wars... I'm just tired of people blaming it on the ability to comment out rows easier. The difference between the two styles only affects the ease...

Heh... that bit of info should be as a comment in the code. 😉

Anyway, works good.

I also don't see anything that would prevent "overruns"... what happens if you use 1001 of any given sequence? Either BOOM or duplication.