Grant Fritchey (1/29/2009)

---

Bruce W Cassidy (1/29/2009)

---

[font="Verdana"]Yup. I added a cross join as well. And the full...

There is...

Jeff,

True, not every parent has a family friendly employer like I do at the moment (I work for a public school district, in fact it is the same one I...

Jeff Moden (1/29/2009)

---

anam (1/29/2009)

---

Brad M. McGehee (1/29/2009)

---

Can any of you math majors calculate what the number of members SSC could potentially have if the site continues to grow at the...

MrBaseball34 (1/29/2009)

---

I actually have it working for all columns but for some reason, the char(13) + char(10) doesn't input a CRLF in the text when I paste it into a...

Bruce W Cassidy (1/29/2009)

---

tosscrosby (1/29/2009)

---

You never will here. Passionate people about SQL server, all willing to help whenever possible (free...

Two places, INFORMATION_SCHEMA views or the system views (not sure which ones off the top of my head).

That doesn't mean the CTE is the problem (if it is a problem). It could be the query written in the CTE that needs to be reviewed.

I've been working with SQL Server for about 12 years, no certs here either. Would not mind getting them as a validation, but i think experience says a lot...

Consultant's answer (while rubbing one's chin) "That depends."

I have found that they make writing some of the more complex queries easier, as well as more readable especially where you may...

Here is some code (that I know Jeff will start shooting pork chops at for having written as it uses a while loop).

Wouldn't let me post directly, so had to...

yes, have that I do. 😛

Your code is all wrong. I am looking for an example of something I have done here at work, I'm just having a problem locating the script I want.

Stay...

Aw, PHP. Yes another forum would be good, web programmer I am not.

I know, wrong avatar, but... I know nothing....

I'm glad you saw it first, now he's yours..... :hehe: