Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by davidhexter
-
string.toUpper()
How do you add the "Code" Blocks to your posts? David Hexter Business/Applications Analyst, DBA- davidhexter
- Post #6
- Forum: C# (C sharp): Microsoft
-
SQL statement requiring correction assistance.
Thank you hmckillop. I forgot that I can add a SQL statement in place of a column (Back to basics!!) Dave- davidhexter
- Post #5
- Forum: Microsoft SQL Server: Programming
-
SQL statement requiring correction assistance.
Sure: Loan (PK = ccmpy_id, cloanid) ccmpy_id cloaid scmpy_id sloanid CAAREAL 1 SAAREAL 1 Company (PK = cmpy_id) cmpy_id cmpy_name CAAREAL Aareal Bank AG SAAREAL Aareal Bank France It is simply a coincidence that the Creditor's Company Id is similar to the Servicing Agent's...- davidhexter
- Post #4
- Forum: Microsoft SQL Server: Programming
-
SQL statement requiring correction assistance.
In the below query, I have two fields (loan.ccmpy_id and the loan.scmpy_id) that relate to the company table's company.cmpy_id field. Pulling in the cmpy_name for the first cmpy_id was simple enough, but I am having difficulty pulling in the company name for the scmy_id field? How do I do...- davidhexter
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
