We can't really help you without table and index DDL, sample data and the query for the report.

John

Brandie

Is this the first time that setting the rate to zero has been invoked? What happens if you set it to a decimal rather than an integer, like this?

...

Gail

The first ORDER BY in the original post matches the clustered index, albeit with the unnecessary addition of a second column.

I think you're right - a sort would be necessary....

I seem to remember that when I tried using an environment variable in a package configuration, I had to restart the computer before SSIS would pick it up.

John

Please can we see your stored procedure definition?

Thanks

John

Gail, reading between the lines, I think what the senior DBA is saying is that if you insert data that is already sorted in the order of the clustered index...

Jeff

Unfortunately I don't. One of my colleagues has written a sophisticated application for use in house. It collects data from servers about all sorts of stuff - file...

Ryan

But how do you want to limit it? First 30 characters? Last 30 characters? Remove all vowels? If you want the first 30 characters, use the...

Ryan

That all depends on your requirements. Here's one way (not tested):

...

LEFT(COALESCE(PROP.postcode + N'/','') + PROP.address ,30)

...

John

Bhuvnesh

What I meant is that you should use an ORDER BY when SELECTing, not when INSERTing. So instead of this:

-- INSERT data into destination table

insert into email_destination_bk

select ut_stub,acct_id...

This method is only useful if the table was created recently enough for the default trace to...

Bhuvnesh

I'm not sure what you're asking, but in any case, why would you use an ORDER BY in a SELECT statement for an INSERT? This doesn't guarantee that the...

Bhuvnesh

If you specify the column to order by by name instead of ordinal position then you get your concatenation.

John

I think your only realistic option is to get on to the client PC and find out what it's running. I'd have thought that a developer might have some...

Only if you are happy for this user/PC/application to be connecting to your database. As Pradeep suggests, use...