Further clarification; not all staff records are missing dates, the ones are missing dates are the ones that need a date from table 2.

So if i query staff attendance...

Table 1 Staff

SELECT [SECTION_GU]

,[ORGANIZATION_NAME]

,[SECTION_ID]

,[COURSE_ID]

,[COURSE_TITLE]

...

Thank you for the answers posted. I am a bit new on scripting Cursors so i was wondering how to use a character for field terminator instead of a comma,...

No, different tables

The table has 67404675, i need to keep 180 days, I calculated about 10,000000 for a year.

Thank you for your quickly reply. So just to confirm the entire script would look like this, right?. Thanks again

DECLARE @days2keep INT

SET @days2keep =180

while @@ROWCOUNT > 0

begin

delete top 10000

FROM...

Thanks Stooky I appreciate it.

Thanks Stooky for you assistance. Yes i do have other fields. i did add them individually in both select statements below but when i do it, it doesn't recognize the...

i may have spoken too soon. when i added new records with more than 4 violations i got duplicates on one id, see attached

;WITH VW_ILLDISC1_Numbered AS

(

SELECT *,ROW_NUMBER() OVER(PARTITION BY [Participant...

Hi i may have spoken too soon. When i introduced more records that have more than 4 violations i get duplicate ids one of them see attached

;WITH VW_ILLDISC1_Numbered AS

(

SELECT *,ROW_NUMBER()...

THANK YOU!!! Yes the second option is the one i needed and it worked. Thanks

see attachment

like this:

Id Incident IDincident1incident2incident3incident4

2853459 140 511

2861733 118 ...

sorry i am new on this forum and got trigger happy. I need each id with uniqe incident id on onerow with each incident across. i did try a pivot...