Yup, no cursor needed at all. Also are you doing this to transfer data? Because I don't see the point of having the same values in 2 different...

I'd throw "Ubiquitous Spook" in there .

Sure you can.

Here's the url :

http://www.sqlservercentral.com/forums/post.aspx?forumid=5&messageid=223067&edit=1

Alright... I also PM Steve to see what the next step was .

I'll start by polishing mine before I polish their's .

It's got a lot of polishing to do before I could go there.

We'd have to be able to do reports based on selected objects and how many levels down we'd...

Try to edit your message using netscape... you'll see any markups and formatting there.

I guess that the next step is 10K .

Not sure if it's faster that way, but you could test it :

SELECT

@biIP = CASE WHEN @tiCount = 4 THEN biOctetA + biOctetB + biOctetC + biOctetD ELSE NULL...

why don't you play with that... seems to be considerably faster :

CREATE FUNCTION dbo.IPStringToNumber_Set( @vcIPAddress varchar(15))

/**************************************************************************

DESCRIPTION: Returns Numeric IP, otherwise returns null

PARAMETERS:

@vcIPAddress - The string containing a valid IP

RETURNS:...

I can't wait to see where this message will end up!!!

Stop using the table html markups (incorrectly at least) .

Basically, when I change a table, I like to know all the objets (client and app side) that may be impacted by the change and retest those. I had...

It would satisfy me too .

If this is going into production, then I suggest you add a where condition like this :

where charindex (' ', columnName, 1) > 0 so that you update only...

If the replace works as you seen to state, then I'd really recheck that where condition to be absolutely sure that it is doing what you think it should be...