Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fine tuning a SPROC
Message
From
21/06/2007 14:32:20
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01234693
Message ID:
01234832
Views:
12
I'll try... thanks!

>Hmmm,
>How about:
>
>DECLARE @Temp TABLE (table1ID int, Table2Id, StartDate Datetime, EndDate DateTime)
>INSERT INTO @Temp
>SELECT Table1.Id,
>       Table2.Id,
>       Table2.StartDate,
>       Table2.EndDate
>FROM Table1
>FULL JOIN Table2 ON 1=1
>
>
>SELECT .....
>    FROM Table1
>    LEFT JOIN @Temp Temp ON Table1.Id = Temp.Id AND Table1.EffectiveDate BETWEEN Temp.StartDate AND Temp.EndDate
>
>I am not sure if this would speed something.
>
>
>>Table1 contains a record for each day that contains certain interest rates.
>>Table2 contains a record for a range of days (specified by StartDate and EndDate - no overlap) that contains other interest rates.
>>
>>I want to link the tables, and view the corresponding Table2 record with each Table1 record. The tables are unrelated otherwise.
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform