I thaught about that too but you still can only get 4 positions.  That's too limited for my taste .

Guessing that it's built in the query by the application.

Anyways this :

HTH, I,'m sure you're not the last one to come across this post in need of the same thing .

Now why would someone want to swap a variable with itself ????

It would seem to me that someone would have forgotten an if statement somewhere...

Actually a single or can be enough to ignore an index.

I'm curious about the 165 ors. It this something you could put in a table and join to it??

Also it...

Dito...  but it's a nice change from the old swap code .

Wow thanx for the tip.  It's almost a shame we can only use this with dot separated text, but it's really nice to have that in the bag

Or you could also use a split function and only return the 2nd element.

DECLARE @demo TABLE (IP varchar(15) NOT NULL)

INSERT INTO @demo (IP) VALUES ('9.200.12.13')

INSERT INTO @demo (IP) VALUES ('11.200.12.13')

INSERT INTO @demo (IP) VALUES ('120.200.12.13')

INSERT INTO @demo (IP) VALUES ('10.0.12.13')

INSERT INTO @demo (IP)...

sp_closePopUps

sp_BreatheIn, sp_breatheOut

sp_blink

sp_PostOnSqlServerCentral

sp_FetchNewSqlServerCentralThreads

just to name a few .

Click anywhere on the plan.  Right click on the plan again, and this time select save execution plan.

I preffer not to use strings manipulation (performance on large datasets)., but your solution could use and else instead of a second if which should make it run pretty fast...

NP... as long as we can see the rest now

Thanx for the quick fix.

Not even gonna try... but I'm lazy and I know this works fine .

Have you considered this one :

For each server

exec sp_msforeachdb 'IF ''?'' IN ('Pubs', 'DBA', 'Production') BEGIN use ? exec ?.dbo.USPDemo END'

next