Does this help?

SELECT *

FROM

#myTableA AS TA

LEFT JOIN(SELECT

*

,ROW_NUMBER() OVER (PARTITION BY ChecklistStepID ORDER BY EndTime DESC) AS RowNum

...

Hi

Without DDL's and sample data it is very difficult to help - could you post these?

The first thing that springs to mind is using a CTE to create a UNIONed...

As Anthony said if you provide DDL's ect you will get much better answers

I'll take a shot in the dark, maybe this will help you or put you on the...

I've used CROSS APPLY many times in...

Gail thank-you, explained so well even I can understand it 😉

I've been using T-SQL/ P-SQL for years and am by no means a beginner, although compared to some of you...

Thanks both

Eugene yep I knew what it was doing it was more a question of is this expected behaviour.

OK dumb question then if all that is needed is to bind...

It's not an execution time error, it's a parse-time error. The parser doesn't execute the IF statements, it doesn't evaluate (or care) which branch the query will run, it just...

Two options spring to mind

As your using an IF you obviously only want one query to be executed

DROP Table #TempProduction before the next IF is evaluated then create it in...

Thanks Anthony - I'll order a copy

I'll probably need a few more books as well then based on your comments, my main role is Data Warehousing and SSRS but recently...

Glad it helped 🙂

Just be careful doing something like this - using the email address to identify new records wasn't the best...

Hi Anthony

Good luck with the exam!

Quick question I'm looking at doing the 70-432 and have looked at buying the MCTS 70-432 self study book but have read very mixed reviews.

What...

You...

To all intents and purposes its an incremental load, only loading records that have changed or been loaded since your...

Does seem a bit long...

Are the destination tables heavily indexed?

Are there no transformations in the ETL?

Could you post the SQL?

Andy

Hi a couple of questions:

Define a bit long?

How large are the tables?

Are you using complex queries to retrieve your datasets?

How many transformations are you performing in your ETL's?

Are you using...