You could use the following to generate an xml statement which would detail your execution plan. Also, have you attempted to use Profiler or the Database Tuning Advisor to...

Just out of curiosity...

I see you are using the WITH (Nolock) Table hint.. Is there a valid business reason for this, because by using this hint you are forcing...

pbyrne (4/7/2008)

---

Maybe I'm missing something, but I would think that datename(m,join_date) like '%a%' would also pull data for the month of August effectively rulling it out as a possbile...

'gratz folks.

thanks for all you do for the community.

-Luke.

Just for the record I chose the Not in list answer, because

a) join Date <> dob

b) There was a syntax error in datename(m join_date) like '%a%' -- no comma...

Not sure how much this will help, but It may help to point you in the right direction...

http://www.sqlservercentral.com/Forums/Topic463445-146-2.aspx

-Luke.

While I agree that competition is good for the market, however I also feel that The windows OS should stay where it is. From a market perspective I can't...

Yeah I knew I needed to normalize the data, I just wasn't sure where to start with this one.

thanks again for putting me on the right track.

@john-2, I...

Thanks, That was somewhat the route I was beginning to proceed down, but I wasn't sure exactly how to break up the table to create something that resembled normalized data.

I...

Steve, I gotta say I enjoyed it, but it seemed far too familiar to me...

http://www.sqlservercentral.com/articles/The+Lighter+Side/sqlserveronlinux/1814/

-Luke.

Thanks for the recommendation. That was one of the ones I was looking at, however it had gotten a number of not so good reviews from a technical standpoint...

Funny you should ask. I just recently installed the beta of Red Gate’s forthcoming SQL Data Generator. While it had some draw backs and limitations, which I'm sure...

instead of using the built in RS rendering for that particular report, you could build an ASP.net page to collect your params. Put a radial button on it that...

Probably not a big consideration since the OP only has a 500MB db right now, but I figured it should be stated. It could be a problem depending on...

Any Reason why you couldn't send either Nulls or '' if the parameter is false and do soem checking in the stored procedure to figure out which is populated and...