Hi thanks for your suggetion,

Where we should use This expression "E:\\Reporting\\Delivered_Reports\\ExcelName_"+

((DT_WSTR,4)Year(GETDATE()))+

RIGHT("0"+((DT_WSTR,2)Month(GETDATE())),2)+

RIGHT("0"+((DT_WSTR,2)Day(GETDATE())),2)+".xls".

In send mail task or somewhere else?

Thanks for your time

Hi,

I have tried with GETDATE() also, but it did not resolve my issue....

Thanks John,

Can you guide me how we can achieve from...

Thanks for your reply

Actually I want to write 3 seperate queries.

For example: For leval 1, I want those rows who has grand children.

...

Hi Table is:

CREATE TABLE Intermediary

(

IntermediaryPK INT ,

...

Hi Rishikesh,

I have tried this query:

SELECT * FROM Intermediaries I1 INNER JOIN

(

SELECT DISTINCT ParentIntermediaryID

FROM Intermediaries

WHERE IntermediaryID = ParentIntermediaryID

) I2

ON I1.IntermediaryID = I2.ParentIntermediaryID

AND I1.ParentIntermediaryID IS NULL

But this query returns...

Hi

I have tried this query:

SELECT * FROM Intermediaries I1 INNER JOIN

(

SELECT DISTINCT ParentIntermediaryID

FROM Intermediaries

WHERE IntermediaryID = ParentIntermediaryID

) I2

ON I1.IntermediaryID = I2.ParentIntermediaryID

AND I1.ParentIntermediaryID IS...

I need to do is first of all I have to get all parents records. This is done by joining Intermediries to itself on ParentIntermediaryID = IntermediaryID (inner join) Now,...

Hi,

Table is:

SELECT [IntermediaryPK]

,[SourceSystemID]

,[IntermediaryID]

,[IntermediaryName]

,[IntermediaryTypeID]

...

Hi Kingston,

Thanks for your quick reply.

...

Hi Bhaskar,

I want to write a SELECT query where validation should return invalid parents in SELECT If table has....

Hi Aadhar..

I want to write a SELECT query where validation should return invalid parents If table has....But your query will return all valid parents I think.....

Can you please give me the query based on the columns IntermediaryPK and ParentIntermediaryPK ? So it should return the output, If any invalid parent is there for...

Thanks for your quick reply....It works exactly as I wanted.. Thank you very much