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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
LTRIM/RTRIM Problem
I have a stored procedure the last part of which has a select statement. I am running an isql batch file to extract the results to a csv file. For some reason when I select on the varchar fields using RTRIM(LTRIM(field.name)), I still get all the leading or trailing spaces. Is there something...- dwearden
- Thread
- Replies: 9
- Forum: Microsoft SQL Server: Programming
-
OLE DB & SQL Client
If the data source is a SQL Server database, does the clinet PC running Crystal always have to have SQl Server client installed. I'm confused because I got the impression specific dll's were adequate. We really don't want the users to have SQL client on their machines if we can get away with it...- dwearden
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Count All Records And Filtered Records
I have a database with two specific fields, datereceived and type (T)or (P). I want to count all records received between two dates, which are set as parameters, but only show records of type T in the report. I have tried using a formula to count the number of records between the two dates using...- dwearden
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
