Hi Jim,

I think that the solution to your problem is right in front of you. The structure that you already have can be used to model the necessary associations, but...

Hi Stefan,

It would be very helpfull for SSC members eager to help you if you post as much structure and exact SQL statements as possible. The solution to the problem...

Hi sahana,

I prefer application reliability to query performance. I would first ensure that there are no time bombs in the DB (like having a table with row size > 8K)...

Hi Scott,

I've read something similar for ORACLE. It said that, basically, there is only one kind of indexes in ORACLE - unique indexes. The same trick is used there, too:...

Hi Ville,

my first hint would be to check the MDAC version on the client machines. MDAC 2.7 or newer is required to access named instances.

Regards,

Goce smilevski.

Hi BPH,

several links on the pivoting (crosstab) subject:

http://www.sqlservercentral.com/scripts/contributions/818.asp

http://www.sqlservercentral.com/scripts/contributions/931.asp

http://www.sqlservercentral.com/scripts/contributions/936.asp

Also, you can search for "pivot" or "crosstab" in tha scripts library .

Regards,

Goce Smilevski.

Hi Hans,

try this (from BOL for MS SQL 2000): in the Index tab of BOL type "execution plan" and double click on the "Execution Plan pane" in the list below....

Hi Simon,

some sample data and desired output result would help me and others to better understand the problem.

Regards,

Goce Smilevski.

Hi all,

Since the ID column is IDENTITY, I would only suggest a replacement of the SELECT TOP 1 ... subquery with this one

(select * from Table1

where ID = convert(int,...

Hi Sairam,

I think that the problem is similar to this one.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=99869

Regards,

Goce Smilevski.

Hi Isaac,

it can be done:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=99869

Regards,

Goce.

Hi,

Even though MS Access is known to be very fast when combo boxes are used, I would not display 50,000 records in a combo box. From the problem description in...

Self-referencing foreign key is supported (I used it, on MS SQL 2000). The syntax does not differ from the standard syntax for creating FK on a different table. based, on...

Hi,

I would create 3 separate indexes. ORACLE uses indexes on FK columns in the child table while validating data, to avoid chld table locking. I don't know yet if MS...

Two usefull links:

http://www.realisticrandomdata.com/

http://www.turbodata.ca/

Regards,

Goce Smilevski.