The datatype of column is ntext

This worked 🙂

REPLACE(CAST(ColumnName AS nvarchar(max)),';#','' )AS [Type]

Thanks.

I used Sub query and it worked.

Thanks

Output should be:

GrandTotal646

AprilMonthTotal60

AprilAgricultural Total1

AprilAgricultural LIVENULL1

AprilAgricultural LIVEWeb1

AprilDatabaseTotal1

AprilDatabaseLIVENULL1

NULLNULLNULLNULL 646

AprilNULLNULLNULL60

AprilAgricultural NULLNULL1

AprilAgricultural LIVENULL1

AprilAgricultural LIVEWeb1

AprilDatabaseNULLNULL1

AprilDatabaseLIVENULL1

The output I require is

MonthMarketEnvironmentReleasetypeID

Grand ...

Thanks. It worked.

The timestamp always appears in the front, and I want to display the string after the ']'

Output is:

2012-03-02 03:30:39.000

Creation of account

02-03-2012 03:31 [GMT +0:00] John Smith: Create user account

2012-03-13 06:30:00.000

I am doing a select from the database for report generation

SELECT ID 'Job ID', date 'Call Date', Calldescription 'Issue', Calldetails 'Details' ,

CONVERT(CHAR(8), DATEADD(minute,totaltime,''),8) 'Time Taken',

status 'Call Status'

FROM TABLENAME

Also,...

checked that already. The local server connection is ticked and the connection string is of the same server, no conflict

I tried a clean install. But the process terminated and i get an error saying No Shared Memory protocol.

SQL gets part installed and terminates.

Is there a way to...

I uninstalled SQL 2005, removed all traces of SQL even from the registry then started new installation.

Installation terminated in between. so SQL server config manager is only part installed....

Yeah...have seen this blog already. Went through all the steps.

Still getting the same error. 🙁