I have to agree that this was a great question and don't see how it could be interpreted any other way. I think the "trap" may have been people...

But based on the desired output he provided it looked like he wanted the % signs removed as well. Or did I misread that?

Edit: Nevermind, I get it...

Does this not work for you?

select REPLACE(yourstring '%sometext%', 'replaced')

from #temp

Very cool. I went to college there. I'm working a couple hours away in Billings now.

Montana.

Just got signed up. Pretty new to SQL and quite a bit of fantasy football experience, but still probably the same skill level at both. Looking to have...

I also just noticed your between criteria in your original query you posted won't return you any results since the first number in your between is greater than the second...

That and the top 5 of your results are not necessarily guarenteed if you don't have a order by statement in your query although I'm not sure if that is...

Top 5 by what criteria? If you show the structure of your table and what you are basing the top 5 off of, we could easily help you find...

D'oh that is what I am doing. Read too fast and...

Will the date always be 8 digits with no punctuation, like dashes or underscores?

Nope that will cause an...

morepainot (8/8/2012)

---

What am I missing in this dynamic sql?

BEGIN

SET @nSQL = '

IF NOT EXISTS (SELECT * FROM '+ @SourceDatabaseName + ' .INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_SCHEMA = ''dbo'' AND

TABLE_NAME...

Maybe my files I am using are encoded differently than yours or maybe I am missing something here, but any time I have had to load a whole line from...

thadeushuck (8/7/2012)

---

When my wife asks my a question that she already asked me a few days ago, I stop and think OH NO I BETTER REALLY PAY ATTENTION AND GIVE...