Your join is on PS.ProjectSafeguardID = S.SafeguardID, but your select is on S.ProjectSafeguardID.  Change your join to PS.ProjectSafeguardID = S.ProjectSafeguardID.

Drew

Because of the GROUP BY, you cannot reference the Keyword field directly in your ORDER BY.  This should work.

SELECT A.ImgName, A.ImgID
 FROM Images A

First, when posting code it REALLY helps if you use the SQL Code button to format your code.

You're using unnecessary WHILE loops.  Get rid of them.  The first...

The documentation has an example on how to create a format file.  You'll also need to use the -t option to change the delimiter to a pipe (from the default...

The documentation on BCP is very good and BCP contains too many options for us to give you an intelligent response with so little information.  I suggest that you Google...

I believe that this will work.

;
WITH event_pvt AS
(
    SELECT t.eventdate, e.is_start,
        CASE
            WHEN e.is_start = 0 THEN 'N'
            WHEN LAG(e.is_start, 1, 0) OVER(ORDER BY...

The join will give you exactly what you asked for.  If it's not giving the results that you expect, we can't help you without more information.