Wir haben da so einen Schönheitsfehler, leider werden immer wieder die Computernamen entweder mit Groß- oder Kleinbuchstaben importiert, dass schaut natürlich schrecklich aus.

Schöne Grüße
Bernhard
Code: Select all
select
ascb.ObjectId,
compcb.name as [compcb name alt],
upper(compcb.name) as [compcb name groß],
lower(compcb.name) as [compcb name klein],
ascb.name as [ascb name alt],
upper(ascb.name) as [ascb name groß],
lower(ascb.name) as [ascb name klein]
from SPSComputerClassBase compcb
inner join SPSAssetClassBase ascb on compcb.[Expression-ObjectID] = ascb.[Expression-ObjectID]
Users browsing this forum: No registered users and 6 guests