Hi brian thanx a lot for ur suggestion. It worked for me but previously when
i use to run my query comprising union it use to took 2 sec. now it has
become 5 sec.

i drafted my query like this as u suggested

strCmd = "SELECT ID,ResId, ResName,ProjId, ProjName, REPLACE(ProjName," +
"'.Published', '') as ProjNameMod,TaskId, TaskName," +
"AssignedWork, TotalWork, TotalCost," +
"AssignedWorkPercentage,CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, " +
"CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ";

int dataTableRowCount = dataTable.Rows.Count;
for (int i = 0; i < dataTableRowCount; i++)
{
DataRow currRow = dataTable.Rows[i];
strCmd += "(ResId = " +
System.Convert.ToInt32(currRow["ResId",DataRowVersion.Current]) +
		" AND TaskID = " +
System.Convert.ToInt32(currRow["TaskID",DataRowVersion.Current]) +
		" AND ProjID =  " +
System.Convert.ToInt32(currRow["ProjID",DataRowVersion.Current]) +
		" AND B_Date = " +
			" (SELECT MAX(B_Date) AS B_Date FROM CST_IVU WHERE ResId = " +
System.Convert.ToInt32(currRow["ResId", DataRowVersion.Current]) +
				" AND TaskID = " + System.Convert.ToInt32(currRow["TaskID",
DataRowVersion.Current]) +
				" AND ProjID =  " + System.Convert.ToInt32(currRow["ProjID",
DataRowVersion.Current]) + "))";

	if (i != (dataTableRowCount - 1))
		strCmd += " OR ";

		}

	strCmd += " ORDER BY ProjId, TaskId";


I have add one more select in this as i was fetching this in loop before
this making this string. Now i hv to do in this query only. Any suggestions
.

Thanx in advance

Regards,
Rohit




-----Original Message-----
From: Brian Freeman [mailto:freeman@C...]
Sent: Thursday, December 12, 2002 9:47 PM
To: sql language
Subject: [sql_language] RE: QUERY OPTIMIZATION ???


one suggestion is get rid of the UNION all you need is multiple where
clauses:

strCmd = "SELECT ID,ResId, ResName,ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod,TaskId, TaskName," +
"AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage,CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, " +
"CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE " +
"ResId = " + System.Convert.ToInt32(currRow["ResId",
DataRowVersion.Current]) +
" AND TaskID = " + System.Convert.ToInt32(currRow["TaskID",
DataRowVersion.Current]) +
" AND ProjID =  " + System.Convert.ToInt32(currRow["ProjID",
DataRowVersion.Current]) +
" AND B_Date = '" + maxBIvuDate + "' WHERE "

for( int i=0 ; i< dataTableRowCount; i++)
strCmd +="(ResId = " + System.Convert.ToInt32(currRow["ResId",
DataRowVersion.Current]) +
" AND TaskID = " + System.Convert.ToInt32(currRow["TaskID",
DataRowVersion.Current]) +
" AND ProjID =  " + System.Convert.ToInt32(currRow["ProjID",
DataRowVersion.Current]) +
" AND B_Date = '" + maxBIvuDate + "')";

		if (i != (dataTableRowCount - 1))
					strCmd += " OR ";
}
			strCmd += " ORDER BY ProjId, TaskId";


so it would look like :
"SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU

WHERE (ResId = 7 AND TaskID = 2 AND ProjID =  25 AND B_Date = '5/12/2002
12:00:00 AM') OR
(ResId = 34 AND TaskID = 2 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00
AM' )

ETC.

This is much, much simpler for processing and should get you what you want.


Brian Freeman
(xxx) xxx-xxxx  ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, December 12, 2002 2:37 AM
To: sql language
Subject: [sql_language] QUERY OPTIMIZATION ???


hie group, SOS help me out

I am gettin error,
Internal Query Processor Error: The query processor ran out of stack space
during query optimization

the query is absolutely fine n it works in sql query analyser n takes 2 sec.

THE QUERY IS ---

for( int i=0 ; i< dataTableRowCount; i++)

strCmd += "SELECT ID,ResId, ResName,ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod,TaskId, TaskName," +
"AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage,CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, " +
"CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE " +
"ResId = " + System.Convert.ToInt32(currRow["ResId",
DataRowVersion.Current]) +
" AND TaskID = " + System.Convert.ToInt32(currRow["TaskID",
DataRowVersion.Current]) +
" AND ProjID =  " + System.Convert.ToInt32(currRow["ProjID",
DataRowVersion.Current]) +
" AND B_Date = '" + maxBIvuDate + "'";

		if (i != (dataTableRowCount - 1))
					strCmd += " UNION ";
}
			strCmd += " ORDER BY ProjId, TaskId";


AND IT BOILS DOWN TO A TWO PAGE LONG QUERY SO CAN U HELP ME OPTIMIZE
IT ------???


"SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 2 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 34 AND TaskID = 2 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E
_IVU  FROM CST_IVU  WHERE ResId = 7 AND TaskID = 3 AND ProjID =  25 AND
B_Date = '5/12/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId,
ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId,
TaskName, AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 34 AND TaskID = 3 AND
ProjID =  25 AND B_Date = '5/12/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 8 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00 AM' UNION
SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published',
'') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
Assign
edWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
34 AND TaskID = 8 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 9 AND ProjID =  25 AND B_Date = '11/19/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 9 AND ProjID =  25 AND B_Date = '11/19/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 34 AND TaskID = 9 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 10 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND Task
ID = 10 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT
ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 15 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 15 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_D
ate, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU
FROM CST_IVU  WHERE ResId = 7 AND TaskID = 16 AND ProjID =  25 AND B_Date 
'10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 16 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 17 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '')
as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
8 AND TaskID = 17 AND ProjID =  25 AND B_Date = '5/12/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 19 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 19 AND ProjID =  25 AND B_Date
= '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId,
ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId,
TaskName, AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 7 AND TaskID = 20 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
8 AND TaskID = 20 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(
CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 7 AND
TaskID = 23 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION
SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published',
'') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 24 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 25 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, As
signedWork, TotalWork, TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10),
B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date,
E_IVU  FROM CST_IVU  WHERE ResId = 7 AND TaskID = 26 AND ProjID =  25 AND
B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId,
ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId,
TaskName, AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 26 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
1 AND TaskID = 27 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SE
LECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published',
'') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
4 AND TaskID = 28 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 5 AND TaskID = 28 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E
_IVU  FROM CST_IVU  WHERE ResId = 6 AND TaskID = 28 AND ProjID =  25 AND
B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId,
ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId,
TaskName, AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 7 AND TaskID = 28 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
8 AND TaskID = 28 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, A
ssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
1 AND TaskID = 29 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 31 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 2 AND TaskID = 32 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, Pr
ojName, REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId,
TaskName, AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 9 AND TaskID = 32 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
2 AND TaskID = 33 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 9
 AND TaskID = 33 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 34 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 35 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR
(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date, 101) as
E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 36 AND ProjID 
25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName,
ProjId, ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod,
TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 37 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 38 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Publish
ed', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 38 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 2 AND TaskID = 39 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 4 AND TaskID = 40 AND ProjID =  25 A
ND B_Date = '11/29/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName,
ProjId, ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod,
TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 40 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 40 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU
, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId
= 4 AND TaskID = 41 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 41 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 41 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, Ta
skName, AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 43 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 44 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 45 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM
' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 46 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 47 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as
 E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 47 AND ProjID 
25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName,
ProjId, ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod,
TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 48 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 48 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
To
talCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 10 AND TaskID = 49 AND ProjID =  25 AND B_Date = '10/18/2002
12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 10 AND TaskID = 50 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
1 AND TaskID = 73 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName
, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as ProjNameMod,
TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 74 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 74 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHE
RE ResId = 7 AND TaskID = 75 AND ProjID =  25 AND B_Date = '10/18/2002
12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 75 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
2 AND TaskID = 76 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 3 AND TaskID = 76 AND
ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
4 AND TaskID = 76 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 6 AND TaskID = 76 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjNam
e, '.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork,
TotalWork, TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101)
as B_Date, B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM
CST_IVU  WHERE ResId = 7 AND TaskID = 76 AND ProjID =  25 AND B_Date 
'11/29/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 8 AND TaskID = 76 AND
ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
2 AND TaskID = 77 AND Pr
ojID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
2 AND TaskID = 78 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 2 AND TaskID = 79 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B
_Date, B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU
WHERE ResId = 3 AND TaskID = 80 AND ProjID =  25 AND B_Date = '10/18/2002
12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 4 AND TaskID = 80 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
6 AND TaskID = 80 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod
, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 80 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 80 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 3 AND TaskID = 81 AND ProjID =  25 AND B_Date = '10/18/2002
 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 4 AND TaskID = 81 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
6 AND TaskID = 81 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_D
ate, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 7 AND TaskID = 81
AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID,
ResId, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
8 AND TaskID = 81 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 4 AND TaskID = 82 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, T
otalWork, TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101)
as B_Date, B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM
CST_IVU  WHERE ResId = 2 AND TaskID = 83 AND ProjID =  25 AND B_Date 
'10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 3 AND TaskID = 84 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
4 AND TaskID = 84 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResI
d, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
6 AND TaskID = 84 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 7 AND TaskID = 84 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CS
T_IVU  WHERE ResId = 8 AND TaskID = 84 AND ProjID =  25 AND B_Date 
'10/18/2002 12:00:00 AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName,
REPLACE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 3 AND TaskID = 85 AND
ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
4 AND TaskID = 85 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPe
rcentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10),
E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 6 AND TaskID = 85
AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM' UNION SELECT ID,
ResId, ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
7 AND TaskID = 85 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00 AM'
UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLACE(ProjName,
'.Published', '') as ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork,
TotalCost, AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date,
B_IVU, CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE
ResId = 8 AND TaskID = 85 AND ProjID =  25 AND B_Date = '10/18/2002 12:00:00
AM' UNION SELECT ID, ResId, ResName, ProjId, ProjName, REPLA
CE(ProjName, '.Published', '') as ProjNameMod, TaskId, TaskName,
AssignedWork, TotalWork, TotalCost, AssignedWorkPercentage,
CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU, CONVERT(CHAR(10), E_Date,
101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId = 7 AND TaskID = 87 AND
ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM' UNION SELECT ID, ResId,
ResName, ProjId, ProjName, REPLACE(ProjName, '.Published', '') as
ProjNameMod, TaskId, TaskName, AssignedWork, TotalWork, TotalCost,
AssignedWorkPercentage, CONVERT(CHAR(10), B_Date, 101) as B_Date, B_IVU,
CONVERT(CHAR(10), E_Date, 101) as E_Date, E_IVU  FROM CST_IVU  WHERE ResId 
8 AND TaskID = 87 AND ProjID =  25 AND B_Date = '11/29/2002 12:00:00 AM'
ORDER BY ProjId, TaskId"