Viewing 15 posts - 1 through 15 (of 23 total)
The datatype of column is ntext
February 4, 2014 at 5:57 am
This worked 🙂
REPLACE(CAST(ColumnName AS nvarchar(max)),';#','' )AS [Type]
February 4, 2014 at 2:42 am
Output should be:
GrandTotal 646
April MonthTotal 60
April Agricultural Total 1
April Agricultural LIVE NULL 1
April Agricultural LIVE Web 1
April Database Total 1
April Database LIVE NULL 1
January 21, 2014 at 7:45 am
NULL NULL NULL NULL 646
April NULL NULL NULL 60
April Agricultural NULL NULL 1
April Agricultural LIVE NULL 1
April Agricultural LIVE Web 1
April Database NULL NULL 1
April Database LIVE NULL 1
January 21, 2014 at 7:42 am
The output I require is
Month Market Environment Releasetype ID
Grand ...
January 21, 2014 at 7:35 am
Thanks. It worked.
April 12, 2012 at 7:22 am
The timestamp always appears in the front, and I want to display the string after the ']'
April 5, 2012 at 7:15 am
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
April 5, 2012 at 5:23 am
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,...
April 5, 2012 at 5:15 am
checked that already. The local server connection is ticked and the connection string is of the same server, no conflict
September 14, 2010 at 5:29 am
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...
August 17, 2010 at 9:29 am
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....
August 17, 2010 at 2:45 am
Yeah...have seen this blog already. Went through all the steps.
Still getting the same error. 🙁
July 8, 2010 at 8:39 am
Viewing 15 posts - 1 through 15 (of 23 total)