Right, said I would rebook the exam and so I have, roll on the 14th December @ 10:30

Time to get my head in the books again and dig out my...

Doh..... missed that part

if you take a look at the MSDN link Dev provided it doesn't mention Windows2008R2 in the article, so I wouldn't install SQL2005 on Windows2008R2

You can install on Windows2008

noticed this string split function in a number of peoples signatures, maybe will help

http://www.sqlservercentral.com/articles/Tally+Table/72993/

D. van Braak (11/30/2011)

---

Thanks for your replies.

However, MSC is not made to maintain 5000 users :-). I'd agree that SQL not is designed to manage AD, but there are...

take a look at this URL http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx, it has the feature comparisions for all version of SQL2008 which should help you choose the right product for you.

You could try SBS2011,...

this is the script we used to populate our postcode table,

its written for MySQL, so need to just change it ever so slightly with putting in ' in the right...

if you can post me your northings and eastings, then I should be able to get a lat long for it from the data we have as it also contains...

yeah, thats the problem I am having now, I have ordered it by latitude then longitude and getting some funny shapes with LINESTRING, think I am going to just do...

nope. thats amazing thanks.

now just to get it to drawn the polygons, but that will be a different problem for a different topic

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...