SEARCH FOR CUSTOMER BY NAME IN ADMINISTRATION

Thanks for the contribution ljohnson...!

Good idea, but I have a suggestion :
Temporary tables are materialized, can have constraints and have metadata. But we do not use them.
CTEs are not materialized, like a simple view, and I think could be in this case lighter than temporary table.

I have no time for the moment but it would be interesting to compare both solutions ?
Regards,
Nicolas

Great! Just what i was looking for.

Thank you bfranklin825 and ljohnson!

Hi guy,

I have used this code for my 1.80 All is fine.

Now i have another Web site with 1.90 Nop but  'dbo.Nop_CustomerLoadAll' does not exist any help ?

Thank you.

It worked fine with 1.50 not 1.80
In my 1.80 i just activate username. but it's not the same thing ;)