Thank you.  Yes, I used created date order by and it works using function last_value.

Thanks

Thanks.

Thanks. It was duplicate due to internet issue.

Thanks.

How can we handle if we have more than 100 records.. This is only for one FailedNumber but looking for multiple failedNumber..

Thank you.

All Databases is on same Instant but instance are different as well.. This is requirement as per DBA.

So We have different instance for Dev, Test and prod & database name...

Yes,,  Using SSIS - 2012.

How can i use stored procedure in Data flow task ?

Am i need to write dynamic SQL ? Is there any other option  ?

Thanks

B

T

It should be always 1 or 2 in Source data. Want to display different column in report based on event.

Thank you.

That should work. Order is doesn't matter.

Thanks

Hi,,

I don't think, we are able to create view with Option(MaxRecursion 1000) Option.

Now this is really challenging for me, because due to this, my SSIS package is failing .

Thanks

I am having 120 recursion. and based on code, I don't know where to put.

It's very hard to bring data for all those tables.

CREATE VIEW [dbo].[test]

AS

WITH CTE_SUBJECT_VISIT_SCHEDULE AS

(

SELECT s.Subject_ID

,ce.ClinicalEvent_ID

...

If I use maxrecursion in query, is this change server level the thesold or database level ?

Can I implement in production ? What is the advantage and disadvange ?

Thanks

Bhavesh

OK.. Thanks.

Let me check.