I think Phil meant "Welsh" not "Cornish"

possibly ??

SELECT tb_1.SKU1,

tb_2.SKU2

FROM tb_1

INNER JOIN tb_2 ON LEFT(tb_1.SKU1, CHARINDEX('-', tb_1.SKU1)-1) = tb_2.SKU2;

maybe maybe not....would be a whole lot easier with sample data.....:doze:

WITH cte

AS

(SELECT zipcode,

ROW_NUMBER() OVER(PARTITION BY ZipCode ORDER BY ZipCode) AS rn

FROM Postal_Codes_Import

)

INSERT...

Eirikur Eiriksson (1/14/2016)

---

krypto69 (1/14/2016)

---

Thanks everyone - very intersting input.

I ended up using:

CREATE TRIGGER NoDeleteMedicalGroup ON dbo.Medical_Group

INSTEAD OF DELETE

AS

BEGIN

ROLLBACK;

END;

No items in the Medical group table should ever be deleted....

possible solution ??

USE TEMPDB;

IF OBJECT_ID('TEMPDB..yourtable', 'U') IS NOT NULL DROP TABLE TEMPDB..yourtable ;

CREATE TABLE yourtable(

PlanName VARCHAR(5) NOT NULL

,YearID ...

sorry

http://www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/

this link may help you

http://www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/

SQLisAwE5OmE (1/11/2016)

---

J Livingston SQL (1/11/2016)

---

is there any reason why you cannot / will not provide sample data for your table?

am sure it will make providing you a tested solution so...

is there any reason why you cannot / will not provide sample data for your table?

am sure it will make providing you a tested solution so much easier for everyone.

give us a clue......how close? whats incorrect?

sample scripts as already asked...

GilaMonster (1/11/2016)

---

Steve Jones - SSC Editor (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did...

karine.gambarjan (1/11/2016)

---

Sorry guys, I'm complete newbie on this forum!

In the beginning I just wondered how do I define DATEDIFF =1 between two data rows for the same Product and ID....

your rules appear to change as you go along.......please read this article and post back with some scripts that fully demonstrate what you require.

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum

shot in the dark

SELECT product,

...

Hi

welcome to SSC......

your question isnt clear to me...suggest you read following article and post back.

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum

you, me or OP?