The qeustion was how can i convert the code in SQL (Expression). When you read the expression its says when event_type is i then + number zo i + 00000..

Im...

John Mitchell-245523 (8/13/2013)

---

Either:

SET IDENTITY INSERT ON

INSERT INTO WhatsUp_Assyst_replicatie_All.dbo.device

(nDeviceID, nDefaultNetworkInterfaceID)

SELECT nDeviceID, nDefaultNetworkInterfaceID

FROM WhatsUp_Assyst_replicatie.dbo.device

SET IDENTITY INSERT OFF

or:

INSERT INTO WhatsUp_Assyst_replicatie_All.dbo.device

(nDefaultNetworkInterfaceID)

SELECT nDefaultNetworkInterfaceID

FROM WhatsUp_Assyst_replicatie.dbo.device

I would recommend the second method, since you are likely to get...

When i start with a new database and begin with the first database to put into the device table it works...

When i going to databse 2 its saying this again;

Msg...

I want this databases with the table device;

WhatsUp_Assyst_replicatie

WhatsUp_Assyst_replicatie2

WhatsUp_Assyst_replicatie3

WhatsUp_Assyst_replicatie4

in the database;

WhatsUp_Assyst_replicatie_All

:::HERE JOHN:::

USE [WhatsUp_Assyst_replicatie_All]

GO

/****** Object: Table [dbo].[device] Script Date: 13-8-2013 13:37:13 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE...

How can i get the DDL file? Im not so favorite of shortcuts. Step by Step

What do you mean can you do it with a example?!

I get the following error:

Msg 8101, Level 16, State 1, Line 2

An explicit value for the identity column in table 'WhatsUp_Assyst_replicatie_All.dbo.device' can only be specified when a column list is...

What I want. In the picture you see the 2 column 1 with a letter and other with number. I want to combine those to so if it is i...

pgt892 (8/7/2013)

---

Below are instructions for handling your concern in SSRS, the case expression should handle it in SQL.

I set up a simple data set to make this work, containing the...

Still same.

I just trying that but is solve only the 2 and the third telling that the syntax is incorrect.

if i do that i get a syntax error.

Its say now this.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'case'.

I have change a little bit (select and from statement) And the '0000' (in...

In the example you see that i must use the = 🙂 now im use it but.. I get a syntax error..

See picture.

It is in the expression box.

Look picture