i logged in on the same account that the sql agent service runs under, changed security of the package to

"encrypt sensitive with userkey"

sis package now runs fine!

not sure what configurations will do for me Koen?

do i need to change protection level - should it be "encrypt sensitive with password?"

i can only run the app out of hours hence why i cant test now

that has definitely helped!

i didnt even have any reason/need to convert the date, cheers for that tip ! 🙂

hi Chris

i ordered the statement and created the index but its still really slow,

i think i might be best rebuilding this, as the new field was a last minute requirement

thanks

mal

hi, think thats it attached?

cheers for help, i think you have helped kick my brain into operation!

cheers for , this i must have a play with it to see if i can use it!

the problem is i only want the customer record ignored if it...

i think i am probably best going back to the drawing board, the query wasnt written with the customer break down in mind, so i could easily sum per load,...

not far off, its order picking data grouped by distribution load

each load no can consist of orders for 1 or more customers,

some of these orders have part pallets of...

https://skydrive.live.com/redir?resid=A27225A35A5E094C!169&authkey=!ANdqlkPfcG7dymU&ithint=file%2c.xlsx

i have broken down the results of each sub query in this

do you understand my issue?

m

yes i do think i have ex pained it quit poorly !

ill see if i can get some of the data in

thanks robert, this sounds fun!

when i check the sql event log i see ANONYMOUS LOGON attempts each time i run the report

ignore me

the problem was a "where" Date >

i indexed that and viola, results 🙂

- i would delete the post but i dont think there is an option to do...