I think I see a trip...

Take a look at this:

http://www.sqlservercentral.com/stairway/72494/

Andy

+10000 !! 😀

I'm quite fond of Banana Bread Beer - Sounds a bit unusual but it works!

Andy

Hi

You can do this using NOT EXISTS

DECLARE @TABLE AS TABLE

(Groups INT, Application VARCHAR (50), PK INT)

INSERT INTO @TABLE

(Groups, Application, PK)

SELECT 1970, 'blogs', 51284 UNION ALL

SELECT 1970, 'collaboration', 51285 UNION...

Hi

You will probably be better posting the DDL's rather than attachments as people may be unwilling to open them

Andy

As you are nesting views (which isn't a good thing IMO anyway) within your query in order to script the sub queries for you we would need to see the...

Not 100% what you mean, but if you mean can you order the sequence that the dataflow executes then yes.

In your dataflow task start with source 3 , then link...

Sure you'll nail it next time Anthony..

On the up side at least you've had some good news to offset the exam news! 🙂

Andy

Thanks...

Hi looks like you are trying to work out your Six Sigma phase duration excluding weekends?

Have you considered using a calendar table for this it could save you quite a...

I had the same problem recently so did a bit of digging and it is a known issue

I haven't tried this yet but this Link may help.

Andy

How many records are there in total in your table?

The reason I ask is that you could SELECT the records you want to keep using a SELECT INTO statement to...

Don't get me wrong we do use views where appropriate I suppose I'm just a little more cautious these days (and maybe a little jaded ;-)) when it comes to...

The next 7 days from the current date, the SQL...

You could add ROW_NUMBER() in your query and process WHERE ROW_NUMBER() < 10000 , WHERE ROW_NUMBER() BETWEEN 10001 AND 20000 ect

Andy