And i need 5 million euro in my bag.
Your Problem is easy to solve.
Use this script to search for what you want.
1st
Code:
SELECT id, StringResource.value, rank
FROM Arcadia.dbo.ItemResource
LEFT JOIN Arcadia.dbo.StringResource
on name_id = StringResource.code
where value like '%search%' -- search here
order by id, value, rank
2nd
Code:
use
Arcadia
go
select * from StringResource where value LIKE '%search%' --search here
Anyone has a solve for my problem?