back to the OP to detail which version of Sybase they are running then, replace was introduced in ASE 12.5.2

also for the RPT.RegionPolygons table

CREATE SCHEMA RPT AUTHORIZATION DBO

GO

CREATE TABLE [RPT].[RegionPolygons](

[ID] [int] IDENTITY(1,1) NOT NULL,

[PostcodeRegion] [char](2) NULL,

[LatLong] [varchar](max) NULL

) ON [PRIMARY]

Thanks, the below should create the #temp table and insert the values from the attached excel file.

The rest of my above code should compile against this #temp table

edit, missed...

direct from sybase BOL http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.blocks/html/blocks/blocks213.htm

syntax is exactly the same as the SQL function

REPLACE('abcdefg','cde','xxx')

gives abxxxfg

Got a working solution, not very nice but it works

select

ROW_NUMBER() OVER(PARTITION BY dbo.RemoveNonAlphaCharacters(PostCode) ORDER BY dbo.RemoveNonAlphaCharacters(PostCode)) AS RowNum,

dbo.RemoveNonAlphaCharacters(PD.PostCode) AS PostCodeDistrict,

Latitude,

Longitude

into

#temp

from

PostcodeDistrict PD

create table #t2 (id int identity, pcd char(2), latlong...

table with the customers which has a uniqueidentifer column which has a default of newid so each customer has a GUID

then have a foreign key constraint to table 1 which...

I'd agree with Usman, SQL wasnt designed to manage AD.

MS provide the MSC console applications to modify AD objects and they work and do the jobs you need.

Powershell can be...

declare @text nvarchar(100)

set @text = '1,2,3,4'

select @text = replace(@text,',',''',''')

select @text

gives output as -- 1','2','3','4

select * into PRODUCTIONDB.SCHEMA.TABLENAME from RESTOREDDB.SCHEMA.TABLENAME

make sure you have backed up the PROD db and either renamed or dropped the table which you wrongly updated

There is no difference in connecting to the Nodes IP and the Virtual IP. Infact I would almost certainly say always use the Virtual IP address. I say...

duplicate post, please redirect replies to this topic http://www.sqlservercentral.com/Forums/Topic1212917-391-1.aspx

you probably wont find the code as that would break the licence terms of the product.

the stored proc is an extended stored procedure which calls a DLL if I remember...

not to worry, happy to help, is always the simple things that wind you up the most.

You need to run the script, by pressing F5 or the execute button on the toolbar with the red ! mark

when you changed the path to the log files, did you copy the existing log folder to the new location after the config change, or did you delete the old...