DBC REINDEX re-indexes the user-created indexes.

If you ever look in the sysindexes table, you'll see a bunch of other indexes named _WA_Sys_.

These are not true indexes but are the statistcis...

Related topic from yesterday:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=157768

It is possible, but your requirements/specifications are incomplete.

Are there only 4 GNO's, or can there be more ?

Does each BNO *always* have exactly 4 GNO's ?

You should be able to do this as a set-based operation without cursors or local variable declarations:

Update testtable

Set field4 = o.field4

From testtable As t

Inner Join inserted as new

  On (...

The search table isn't 1st normal form - repeating elements, trying to use a DBMS table like an "array".

The use of individual attribute tables seems to be based on...

Presumably because in a command window, $PATH contains the path to where TCL exists.

Try giving the full pathname to the TCL program. Example, assuming it's "C:\Program Files\TCL\TCL.EXE"

exec master..xp_cmdshell "C:\Program Files\TCL\TCL.EXE c:\tcl_scripts\finddate.tcl"

So after writing all that code, you still don't believe Joe Celko that the design is seriously flawed ?

The solution is to go back to the database design, not to...

2) If a parameter is passed as Null, and you want Null to mean a wildcard, the simplest query to accomplish this does not require any conditional T-SQL code:

Select Firstname,Lastname,Address,Employee_Id

From...

There are 2 design issues here, and something we haven't been told about.

1st off, there are cardinality issues, if 2 or more addresses get updated in a batch, you only...

  Update UPR00100

  set Update_Ind=1

  from UPR00100 As u1

  Where Exists (

    Select *

    From inserted As new

    Inner Join deleted As old

      On ( new.EmployID = old.EmployID and

           new.AdrsCode...

>> The 2nd trigger will update the 1st table (set Update_Ind=1) when there's a update on 2nd table (UPR00200).  So I guess the join is not correct,

It's updating the...

Open the Execute SQL Task in the DTS designer. Make a note of the 2nd item in the General tab, labelled "Existing Connection". Close the dialog and locate the connection...

Look carefully at this:

cast (((NoteCount/OrderCount)*100) as decimal (10,5))as Percentage

You are casting the result of the calculation, not the pre-computed values. Any truncation is happening before you've done your cast.

You need to compare adjacent records for each ProdID, which requires some method to add a rank or sequence to the time series.

In Yukon/2005, there are new SQL functions, including...

Really ?

So even though there's no stated requirement for a 3rd, 4th, 5th choice, you'd lock yourself into a design that uses repeating columns of the same foreign key, rather...