You need to write SQL queries using...

duro654321 (11/17/2012)

---

hello,

right now on my search page the sql query i am using is similar to:

select * from table where name like '%search%'

and it returns the exact phrases perfectly

however...

Jeff Moden (11/17/2012)

---

Raymond van Laake (11/16/2012)

---

...

Regular expressions may be the fastest in another language but they're not necessarily the fastest in T-SQL because of the bit of overhead that a...

You need to use free-text wildcard "*" in your search string!

SELECT *

FROM table_name

WHERE CONTAINS(*, '"*eran*"');

Also, read my previous post regarding hyphens and ampersands... It will make it much more...

CELKO (11/18/2012)

---

I went through the forum and found out a way of concatenating row values into column using stuff, but can't figure out how to remove duplicates and only...

T-SQL is not the language for XML manipulation. It can parse it and it can create it, but...

When working with full-text, you need to remember that it's behaviour is not the same as LIKE.

You will need to do additional work (in T-SQL or/and application) in order...

dwilliscp (11/14/2012)

---

True, just a personal quirk. I find that when I am trying to think through something... I tend to code the thought process. Thus the outer join filtering where...

HildaJ (11/14/2012)

---

I know there is a function in sql to grab the a field value for the next row. I have seen it before but for the name...

does at least one row exist in Plant_Master where company =...

See, the article I've pointed you to, makes the difference!

Your problem is not using table aliases! Your sub query concatenates all rows from dbo.TEST_TABLE2 because your filter it...

Jeff Moden (11/14/2012)

---

Just as a follow up to what Eugenne posted...

If you'd like to know more about how a Tally Table works and how it can be used as a...

Many work places do not allow file downloads from internet...

So, it will be much more helpful if you include your DDL scripts into post. Just wrap them with appropriate "code"...

You don't even need to use your function (especially such slow as it is right now based on loop).

You can do just this:

SELECT p.BILL_NBR

...

If you could follow this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

...