Michael,

  Thanks your your words.

The condidions I guess are (as the book writes)

C1.reshID = C2.reshID

and C1.reshstartDate = C2.reshstartDate

and C1.ReshHudNextAnnualDate is null

and C1.chid < C2.chid

To find out duplicate rows....

Sergiy,

I do not know and ask people on this forum. However, your words make me frustrating because BOL if helped me, I did not need to post my...

Thanks, Wrack. Hope I can save time and money to buy and read them. I am afraid of poorly written books of SQL server I bought before.

Jan,

But when you let user input free format text in an html TextArea and save it in an SQL server table column who belongs to varchar type, how...

PW,

Good helps. Thanks so much.

BTW, OR operator can be used at places where CASE cannot be used in WHERE clause?

Knights,

I applied the 3 ways to do the query, in order, IN, EXISTS, INNER JOIN. They give me the same DTS results

-- 4/A table 'Class' and select only...

Table "SchoolAttendance"

------------------------

AttendanceRuID StudentID AttendanceDate AttendanceTyID RollupCount termID

-------------- ----------- ------------------------------------------------------ -------------- ----------- -----------

15097 169 2006-05-15 00:00:00.000 4 1 NULL

15098 169 2006-05-17 00:00:00.000 4 1 NULL

15172 169 2006-04-03 00:00:00.000 1 1 NULL

15173...

Lynn,

I cannot drop constraint "termID is null" because in table "SchoolAttendanceRU", rows with TermID NOT NULL are ones I do not want to query them. Rows with "TermID is...

Query of stax68

select sat.*

from SchoolAttendanceTy sat

where sat.companyID=1370

and sat.AttendanceTyID = 2

gave me:

CompanyID AttendanceTyID Description ...

The query from stax68 gives me the same problem like "LEFT JOIN" same as "INNER JOIN". That means I cannot get any row for sat.AttendanceTyID = 2 (no row in...

Eddie Wuerch,

Thanks so much for your time spent for my question. Your words are great and really helpful.

Johnsql

Sergiy,

Thanks. I am trying to use a VIEW instead of a UDF. Do we need to re-compile a view in which relevant tables creating the view is changed (structure,...

Sergiy,

I got you. Thanks for your kind explanations and suggestions.

BTW, if I do not use function, then view and stored procedure is used. what is your con and pro for...

Thanks Mr. or Ms 500,

I agree with you to pass a value for udf dbo.fn_GetFamilyMembersOfCustomer(). But if so, then the left join table #tgstinfo can associate with all set of...