Thanks!

I missed that you. I will keep to my origional way.

Have a good day.

Unfortunately it doesn't

It looks like this:

(6 row(s) affected)

-------------------------------------------------------------------

ONE&#x0D ;

TWO&#x0D ;

THREE&#x0D ;

FOUR&#x0D ;

FIVE&#x0D ;

SIX&#x0D ;

(1 row(s) affected)

The output is delivered to a VB.Net app which is saving the output to a...

The output is:

ONE&#x0D ; TWO&#x0D ; THREE&#x0D ; FOUR&#x0D ; FIVE&#x0D ; SIX&#x0D ;

I want to have the following output:

ONE

TWO

THREE

FOUR

FIVE

Best,

Harry

hi adi,

This is the result:

Major Error 0x80040E14, Minor Error 25501

> IF NOT EXISTS (SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'DELIVERYINTRIP'

AND COLUMN_NAME = 'PODID')

ALTER TABLE DELIVERYINTRIP ADD...

don't think so

it only works for sql2005 or higher

I'm using it this way on SQL 2005 Databases for version control:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DatabaseDDLLogging](

[id] [uniqueidentifier] NOT NULL,

[EventType] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PostTime] [datetime] NULL,

[SPID] [int] NULL,

[ServerName] [nvarchar](100)...

I think you don't need the temporary tables.

See if this works?

The only thing I'm not sure of is the DISTINCT in the HAVING statement.

SELECT DISTINCT PR.PrmLog_Acct_Code,

               ...

An Identity for the BatchID doesn't work in my situation. The table is used for simulation purposes and a part of the records is deleted before each simulation run. An...

I have  a table with 1 fields as PK called [BatchID]

The application creating the new record should not be bothered with any logic. So I want to fill this field...