Check out this article for some ideas: http://www.sqlservercentral.com/articles/T-SQL/63681/

Duplicate post. Check out here: http://www.sqlservercentral.com/Forums/Topic557637-1291-1.aspx

What build level are you at? I believe this is an issue related to procedure cache and that SP2 fixed it.

I'm guessing you are getting no matching row is found. This is because the Lookup component is case-sensitive and is actually fairly well-known to struggle when the lookup...

Awesome. Not just the power of TALLY, but the waste of loops!

DBAdmin (8/22/2008)

---

I think this is a problem that will continue to worsen unless/until honesty, integrity, humility, effort, and dedication become fashionable again. These attributes have been called "World War II...

I can tell you it is real easy in RS. At least the color coding part is. I'm not sure how you're running the email part.

DBAdmin (8/22/2008)

---

I appreciate the good comments, but my post was not intended to solicit résumé advice. I understand the different strategies for writing a résumé. However, the initial "read" of...

Chris,

Can you explain the why and how of this:

CAST(4*DATEPART(mi, [IN_Punch])/60 AS INT)/4.00

I would bet that performance-wise your solution will be the best.

Looks just like what I proposed except you used XML EXPLICIT.

In the relational model your addresses should be a separate table as should admission details. Without knowing more I'd go with:

Students,

Teachers,

Addresses,

Admission_Details

Are you going to have multiple addresses per student...

Could you post your solution, if not the one I suggested, so others who may find this thread in a search can benefit?

Thanks,

I'd find another server at the client level and see if that makes the issue repeatable. Odds are it is the different builds.

I'm not trying to beat a dead horse, but the error being returned indicates a permissions problem on the AS400 side. I am not an expert on DB2400, but...

This may not be the BEST way, but I typically use the main AD groups and then if special permissions are needed that only apply to SQL Server then I...