Hi All

Thank you all for this. 😀

Regards

Bo

Thank you all for the replies.

I found a way

Change the dbo users login to SA with this command

exec sp_changedbowner 'sa', true

and then mapped the login to a new user in the database.

Regards

Bo

Hi

Sorry about that, I don't know what I was thinking. I might have over done it with the JOINS, however I don't know I else to combine all my data.

There...

Hi Again

Now I hope you still see this.

But I have done what I been told and I use LEFT OUTER JOINS. But now the query takes 10 min to exec...

It works

I think I am starting to see the error of my previous way of join tables ;). But now I have a lot of statements I have to rewrite...

Tank...

Hi SteveB

I need the where clause. I will try to make some simple sample data that might clearify my problem.

I have 2 tables where my system stores data:

entity

e_string

The tables have...

The [] brackets worked. Thank you

Bo

Thanks the reattach works.

It worked. Thanks

Thank you it worked 🙂

Let me try to make it more clear what I need by an example.

The tabel has the following columns

ID, Incident ID and Time

Incident One

1 1 0,15

2 1...