Click here to Skip to main content
15,921,279 members

Comments by tasneemiram (Top 2 by date)

tasneemiram 8-Feb-13 0:11am View    
SELECT Couses_Name,
(SELECT B.Kilometers_Cancelled
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation))
AS Kilometers_Cancelled,
(SELECT B.Scheduled_Duty_No
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation))
AS Scheduled_No,
(SELECT C.ST1_Date
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation)) AS ST1_Date,
(SELECT C.Scheduled_Kms
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation))
AS Scheduled_Kms
FROM Couses_Master AS A
I want 1st coloum to be displayed completely next coloums data should be displayed in front of 1st col but only in respected rows if no match then tat cell in tat col should be blank or display zero
tasneemiram 7-Feb-13 8:08am View    
Deleted
SELECT Couses_Name,
(SELECT B.Kilometers_Cancelled
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation))
AS Kilometers_Cancelled,
(SELECT B.Scheduled_Duty_No
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation))
AS Scheduled_No,
(SELECT C.ST1_Date
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation)) AS ST1_Date,
(SELECT C.Scheduled_Kms
FROM DOS_TripsperKms_Cancelled AS B INNER JOIN
Daily_Operational_Statistics AS C ON B.DOS_Id = C.DOS_Id
WHERE (C.Depot_Id = @id) AND (C.ST1_Date > @fromdate) AND (C.ST1_Date <= @todate) AND (A.Couses_Name = B.Reason_for_Cancellation))
AS Scheduled_Kms
FROM Couses_Master AS A
I want 1st coloum to be displayed completely next coloums data should be displayed in front of 1st col but only in respected rows if no match then tat cell in tat col should be blank or display zero