Skip to Content
0
Former Member
Apr 11, 2007 at 10:28 PM

Best Practices - Multiple Tables

37 Views

Post Author: lpangelrob

CA Forum: Data Connectivity and SQL

Hmm. I like this forum much better.Anyways... we're a futures company, and SQL Server 2k5 is set up so that there are a couple of ways to get the previous trade date and put it into the report. I want the previous trade date in the report, but I generally can never link the data in the report to the date table, so I get the warning "Your current link configuration contains multiple starting points. / Please be advised that this is generally not supported."6 reports in, it seems as though this creates some problems. When I try to plug in the date from this second starting point, it continuously comes up as blank.Are there any other good ways to plug in arbitrary distinct data (e.g. "select max(process_date) from date_table where process_flag = 'Y'") besides adding commands through Database Expert?