No because first + last name IS NOT A KEY. You'll have to list all possible adress for that name, then they'll have to pick the right one. ...

It's not a setting, it's a formula. But it doesn't matter now, I have a vague idea. Looks like if you can't change the report, then you'll have...

Might be sneaky but...

If not exists (Select flag where..)

begin

select 1/0

--should fail, make this step exit the job on failure.

end

else

begin

--don't do anything>> will go to next step

end

or you could actually control...

It's not about being neat... It's about filtering first, then showing the data. I don't know any other set way of doing this.

Select dtLastEntries.AgentID, dtLastEntries.BookSaleTime, Main.BookingID from dbo.YourTable Main inner join

(Select agentid, max(booksaletime) as booksaletime from dbo.YourTable group by agentid) dtLastEntries

on Main.AgentID = dtLastEntries.AgentID and Main.BookSaleTime = dtLastEntries.BookSaleTime

Simplest way is number_of_rows * avg_size_of_row.

Let's say the avg row size is 1 K, that's over 27 MB of raw data to transfer/present (god knows how much bloating that can...

I might understand this process for huge batch processing that can't hold the user from doing something else. But I can't see that being used on almost every part...

That's why I read the article and stopped using dynamic sql... too much troubles for no rewards at all (most of the time).

How much data is that in MB or GB?

Create a new file group and move the clustered index on that filegroup.

Can't use max in a indexed view.

How much data do you have to present (mbs, rows, columns, size of rows).

Views don't turn into table in dts transfer... are you copying related objects too??

READ THIS :

Change Management

This is just a start. Once you got the principle, move...

CREATE FUNCTION [dbo].[fnvwFacturation_ALL] (@BT as bit = 0, @PS as bit = 0, @TEBT as bit = 0, @TETBL as bit = 0, @DateLimite as datetime, @NoPS AS INT) ...

I'll let you work on that one. Fax it to me when you're done .