How would i create this variable ? it would have to be based on the current month and year (possibly a day as well, this will be confirmed)

Is it possible...

ive worked out what the problem was, I had an additional where clause that checked for null postcodes, that was excluding some rows from the update process. Appologies for...

after some initial testing, im still having problems with the actual update, running this query

UPDATE Address

SET County = mc.CountyName

FROM MasterCounty mc

INNER...

thats great, thanks.

that worked perfectly, thank you.

I ended up creating another database that was basically a copy of the other (on my local server) and I tried the import process locally. From the results it...

already tried the except clause

many thanks for your advice Jeff, much appreciated. I ran your version and it worked in about the same amount of time, but your way has made me much...

already tried that one, it seems to do the job. I wasnt aware of it as its new to sqls server

managed to do it myself in the end

update Address set County = mc.County FROM MasterCounty mc

INNER JOIN MasterTown mt ON mc.CountyID = mt.CountyID

WHERE Address.Town = mt.TownName

I tried running it several times with different integer vales passed in, the first 2 were slower, but the third was faster. The integer values i passed in were...

how do i do that ?

jpgrotator>

parameters>

rotatetime>5

randomplay>false

shownavigation>false

transition>bgfade

width>207

height>162

wmode>window

/parameters>

photos>

photo path="image1.jpg"...

anyone know how to post xml ???

ive tried saving to a text file and attaching it, but you cant subsequently view it !

GSquared (4/29/2009)

---

First, raw XML disappears when you post it in the forums. You need to use the code tags around it, with the XML type, or to attach it...