Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspx

I can't stop laughing. 😀

Royal

If you ask me, the adequate option for this is to use EXCEPT. I have to change the name of a column due to the internet filter configuration in my...

My post is marked as an answer. But I still would like some feedback to make sure that you understand how and why the code was simplified.

Also that you understand...

In that case, you don't need your CASE statement, the LEFT function alone will work fine. 😉

You're probably looking for something like this:

ALTER PROC [dbo].[SupplierStats]

@a nvarchar(50),

@b-2 nvarchar(50)

AS

SET NOCOUNT ON;

INSERT INTO dbo.wanado(

ContactName,

CompanyName)

SELECT CompanyName,

ContactName

FROM Suppliers

WHERE ContactName LIKE @a + '%'

OR ContactName...

That won't return what you asked.

To be sure about the correct formula:

- Will the strings always start with a slash(/)?

- What should be returned if there's only one?

-...

Coke

Jeff Moden (8/22/2016)

---

RonKyle (8/19/2016)

---

Social Security numbers are also not numeric. Once had a...

Sean Lange (8/19/2016)

---

Ed Wagner (8/19/2016)

---

Sean Lange (8/19/2016)

---

Ed Wagner (8/19/2016)

---

RBarryYoung (8/19/2016)

---

Jeff Moden (8/19/2016)

Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal...

You're missing the second parameter and closing parenthesis to either ROUND or ISNULL.

Massacre

joshua 15769 (8/18/2016)

---

Can you tell us a little about your database? Is it something you are in the process of constructing or is it something you have inherited? What is...

kawi6rr (8/18/2016)

---

I’m totally lost, I think it can be done with a union query but I can’t get it to work. Any help is greatly appreciated, thanks in advance.

You...

Shake