Following confirms your understanding.

Similar question at http://dbforums.com/arch/179/2003/6/825836

Want to play around with the following sp, maybe it can be of use to you.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q271/5/09.asp&NoWebContent=1

Will failover clustering be a overkill

Agree with Jonathans solution, maybe first sum per day for available data and then join to year dates. But then again it depends on the distribution of the data.

Also do not know Crystal that well, but you can try and pass the vendors as a comma delimited string to the sp.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=243&lngWId=5

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20666719.html

Thanks for the feedback.

Replace GetDate() with your date parameter your are interested in.

Set NoCount On

Create Table Test(ScheduledDate DateTime,SomeOtherCOl varchar(100))

Go

Insert Test

Select GetDate(),'Date Inside'

Insert Test

Select dateadd(day,3,GetDate()),'Date Inside'

Insert Test

Select dateadd(day,2,GetDate()),'Date Inside'

Insert Test

Select...

Open a command prompt(DOS promnpt) and change your directory to C:\Program Files\Microsoft SQL Server\MSSQL\Binn

Type

TEXTCOPY.exe /?

The program should display the help menu.

Open Windows Explorer and search for TEXTCOPY.exe

If you do not find it on your own pc search the SQL server machine for it.

C:\JNK.ico is the filename of an icon which I have loaded into the database with the program TEXTCOPY.exe

C:\JNKII.ICO is the filename where the the image was stored, when retieved from...

Cannot comment on the 'efficiently', suppose DTS will be faster.

Alternative is to select the data directly from Access databases.

Select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source="\\Servername\Shared\Example1.mdb";

User ID=Admin;Password=;')...Tablename 

Can also...

quote:

---

Junction Table

BOL 2000

You create such a relationship by defining a third table, called a junction table, whose primary key consists of the...

Have a look at http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=18898