Not 100% sure what you are trying to do here but I think you are trying to implement...

I have an app that I'm adding a generic search function to. The user types in a word, or phrase, or portion of a word, and all items matching this...

I stand by my comment that this entirely too vague to provide an answer. What does...

Questions 1 and 5 do not have enough details to provide an answer. I would be asking for a lot of clarity about what those mean. 2, 3 and 4...

nick.wright 69367 (12/4/2012)

---

That's great, Sean. Unfortunately, being an "agile" kind of developer, the ink on my code is still wet as it goes into a live environment ;-). The new...

It would not work inside a stored proc. It would end the batch. 🙂

For example if you have a script that create a stored proc and a view you HAVE...

Sounds like you should look into a calendar table. Check out this article. http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D

Hi and welcome to SSC. In order to be able to provide an answer we need some details. Specifically we need ddl (create table statements), sample data (insert statements) and...

Or even this.

IF cast('12/04/2012' as datetime) < cast('03/01/2013' as datetime)

select 1

Shadab Shah (12/4/2012)

---

anthony.green (12/4/2012)

---

GO is a batch sperator.

So you could say

Do Something

Do Something Else

Do Something More

GO

Do Something Even More

Do Something Better Than Before

GO

And it would execute the first three things...

nick.wright 69367 (12/4/2012)

---

Thank you very much for this. I wouldn't normally use a while loop in a function, but looking at the replace/substring code I've written in the past to...

Isn't this the same question you posted yesterday??

http://www.sqlservercentral.com/Forums/Topic1391849-391-1.aspx

Please stop cross posting. You don't need to start a new thread for each follow up question.

http://www.sqlservercentral.com/Forums/Topic1392324-391-1.aspx

Hi an welcome to SSC. It is impossible to provide any detailed help based on your post because there just aren't any details. I think that maybe what you want...

It is called SARGability. When you add that where clause it causes a full scan. It has to evaluate every single row to determine if it belongs in the result...