Search results for query: *

I am using Crystal Reports XI and MS SQL 2000. I have a parameter in a SQL command for my report called "Report Date" which both filters records returned to the report as well as assists with calculations of a loan balance at that date using a sub-query. If I run the report with just this...

We have an unusual problem in that we have had to use special delimiters for fields and rows to export data into text files. This is because some of the data in the fields contain commas, quotes and carriage returns. We have used the tilde (~) to separate fields and the vertical bar/pipe (|)...

I am using a Union statement to combine 2 aggregate (sum) select statements but I really want to sum the whole lot where the ParentID is the same number. My statement as it stands is: SELECT Ref_Code AS ParentID, SUM(LMR_CurrentLoanBal) AS CurrentLoanBalance FROM Loan_MasterReference WHERE...

I have a table of loans where 1 loan can be a parent and can have multiple children. The table looks like this: LoanID ParentID LoanBalance 1001 0 200000 1002 1001 300000 1003 1001 250000 1004 0 500000 In this example loan ID 1001 is the parent...

I receive a NDR 5.2.3 stating "This message is larger than the current system limit or the recipient's mailbox is full. Create a shorter message body or remove attachments and try sending it again." on e-mail that is being sent external to our network. I have been testing this with...