I looked at the query execution plan for the view and it is using the underlying indexes of the tables.

Thanks for your input.

Does it mean that the index of the base table will be used when querying...

This has worked for me. I use VB.Net but should not make a difference for VB 6.0

Private Sub SetCrystalParameterDate(ByRef crParamFieldDefs As ParameterFieldDefinitions, _

...

Look up sp_defaultdb in BOL. Basic syntax is

sp_defaultdb [ @loginame = ] 'login', [ @defdb = ] 'database'

Try this.

[font="Courier New"]Private Sub VoteCount_BeforeUpdate(Cancel As Integer)

Dim x As Integer

If VoteCount.Value <> Int(VoteCount.Value) Then

x...

It should be Raiserror (with a single 'e')

Other options in this link[/url]

You may want to a take a look at this script.

SET @path_holder=(select f.FolderPath, d.DocumentID from xsdl_Folder f, xsdl_Document...

Do a search on this site and you will find many threads on this topic. Here is one.

What are the data types of the 2 columns - can you give us sample data?

What error do get ?

You will need a Numbers table to get the date range. You can get the script to create the numbers table from here

DECLARE @tbl TABLE(PkID int, Start_Date datetime, End_Date...

DECLARE @tbl TABLE(KeyID int, Dept int, Dt datetime)

INSERT INTO @tbl

SELECT 12345,    13,    '9/16/2007'

UNION

SELECT 12346,    13,    '9/14/2007'

UNION

SELECT 12358,    10,    '8/16/2007'

UNION

SELECT 12365 ,   10,    '4/17/2007'

UNION

SELECT 12398,     9,    '1/1/2007'

UNION

SELECT 12600,    13,    '3/1/2007'

UNION

SELECT...

There is Express edition Toolkit if you are interested

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

Do a join to one of your main tables that has EmplID

SELECT a.EmplID,

COALESCE(C.PhoneType, H.PhoneType,'') PhoneType,

COALESCE(C.PhoneNumber, H.PhoneNumber,'') PhoneNumber

FROM MainTable a

LEFT OUTER JOIN tblPhoneNumbers C ON a.EmplID = C.EmplID AND C.PhoneType...