Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-11-13 : 19:30:48
|
| Withdrew the question. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-13 : 19:40:59
|
| Objection your HonourDamian |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-11-13 : 19:54:44
|
| sustained!- Jeff |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-11-13 : 20:07:03
|
| No soup for you!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-11-13 : 20:18:18
|
| I had considered saying "Question withdrawn your honor." you guys crack me up.Lemme restate the question. If I have a generated recordset (see the red below), is there a way to specify a hint or index to improve performance or .... ??Example:SELECT whateverFROM Users UCROSS JOIN (SELECT DATEADD(dd, TallyID, GETDATE() FROM dbo.Tally WHERE ID BETWEEN @start AND @FINISH) X?? |
 |
|
|
|
|
|