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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Constrain a quey by Case conditions Results
Situation: 'The ValidDate Case will convert all erroneous dates into functional dates. Problem: I need to be able to use a where condition (ValidDate > '01/01/1900'...)to get the results I need. When I attempt this I get Error: 'The column prefix 'ValidDate' does not match with a table name...- ipoppy28
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
XML File as ODBC Data Source for Crystal 8.5
The crystal Documentation indicates Row or Table hint is required. How is this accomplished using a file that containing data from multiple tables in a relational model?- ipoppy28
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
