Wow!

This is what I wanted. I've converted it to my own report and it looks great!

I also changed the "X" with the ServiceWindow, so I get 2in1. Many thanks.

(I've...

For as far as I can see is your output just what I like to see.

I can't see how you do it, the .bmp is not telling the information for...

What you can do is, modify your dataset by adding the next to your original select statement:

Make sure that...

YIPPIE!

When I use the next code, it works! Thanks!

select srelatie.naam,srelatie.adres

from

srelatie

inner join [am1-sqls03a\sqls03a].Topdesk.dbo.vestiging TDName

on srelatie.debiteurnummer COLLATE DATABASE_DEFAULT =TDName.debiteurennummer COLLATE DATABASE_DEFAULT

The collation of the Column "debiteurennummer" is not...

When I use Alias, I've get the next error:

Cannot resolve the collation conflict between "Latin1_General_CI_AI_KS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

I've checked the collation of the both Tables, but...

Ok... I've created the linked server.

But when I've query both of my databases, I get the error:

The multi-part identifier "[am1-sqls03a\sqls03a].Topdesk.dbo.vestiging.debiteurennummer" could not be bound.

Query:

select *

from

srelatie

inner join [am1-sqls03a\sqls03a].Topdesk.dbo.vestiging

on...

I think I had the same problem. Look at:

http://www.sqlservercentral.com/Forums/Topic655885-1292-1.aspx#bm659745

Select

ALIAS1.naam,

ALIAS1.Aantal_Incidenten,

ALIAS2.Aantal_Inc_Portal

FROM

(

select vestiging.naam, count(*) as Aantal_Incidenten

from incident,...

I've found the solution here in an article on SQL ServerCentral.

I can use =IIF(Parameters!P_Dienst.Value="C1" or Parameters!P_Dienst.Value="ALL", False,True)

If one of the values is there, then HIDDEN=False (The True value) otherwise HIDDEN=True...

This is correct. When you create a new Project, the templates won't show.

When you enter you newly created project en add a new report (not by wizard) then they will...

I found a solution for my problem, so I'll share it with you guys 😉

select

substring(inv_machine.name,1,charindex('_',inv_machine.name,1)-1) as Machine_Name,

from

inv_machine

where

CHARINDEX('_', inv_machine.name) > 0

This code will look at the length of...

Thanks for the help. I'm going to try make it work!

One difference, I've to delete the characters AFTER the _

I hope this works the same way?

In this case it's not always 4....

The structure is always the same: aaaaaa_BBBBBBB

But aaaaa can be a different length and BBBBBB also.

I'dd like to get rid of the "_BBBBBBBB"...

Related question:

What if I like to do the same, but than on the right site?

Query result (table)

DC01_CUSTOMER

CS01_CUSTOMER

FileServerName_CUSTOMER

lose the _CUSTOMER, so the result is:

DC01

CS01

FileServerName

COOL 😀

It works! Many thanks and another sql thing learned!

I got the next errormessage:

Argument data type ntext is invalid for argument 1 of reverse function