ScottPletcher (10/7/2015)

---

Michael L John (10/7/2015)

---

ScottPletcher (10/7/2015)

---

For efficiency, try this. It is also easy to extend this to include/exclude multiple ingredients.

SELECT ra.Recipe_number, r.Recipe_name

FROM (

SELECT Recipe_number

...

SQLPain (10/7/2015)

---

Can somebody check my naming convention and see what am I doing wrong here:

,(Select Count(C2.AppID) From Channels c left join Applications a on c.ChannelID = a.SourceID left join...

ScottPletcher (10/7/2015)

---

For efficiency, try this. It is also easy to extend this to include/exclude multiple ingredients.

SELECT ra.Recipe_number, r.Recipe_name

FROM (

SELECT Recipe_number

FROM tblRecipeAllergen

...

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Pass the values in as a comma separated string, and join to or use where exists to the above referenced function.

FROM Table X

INNER JOIN DelimitedSplit8k('parameter values', ',') S ON...

Ed Wagner (10/6/2015)

---

Grant Fritchey (10/6/2015)

---

Michael L John (10/6/2015)

---

Ed Wagner (10/6/2015)

---

BWFC (10/6/2015)

---

I can't get my head around that kind of attitude, particularly...

Ed Wagner (10/6/2015)

---

BWFC (10/6/2015)

---

I can't get my head around that kind of attitude, particularly when there'e so much to learn. ...

Welsh Corgi (10/5/2015)

---

Michael L John (10/5/2015)

---

Do yourself a favor. Invest in yourself.

Look at this site:

http://www.sqlservercentral.com/stairway/72401/

Read this series. Almost all of your questions are answered in this...

Do yourself a favor. Invest in yourself.

Look at this site:

http://www.sqlservercentral.com/stairway/72401/

Read this series. Almost all of your questions are answered in this series.

There are numerous articles...

Lynn Pettis (10/5/2015)

---

Ed Wagner (10/5/2015)

---

You know, I think the Silver Spoons are going to need to be reordered - I'd suggest at least a case. SS is in rare...

Why don't you just create a new publication for the new articles? Leave the existing one alone.

This is normal. I've seen the same thing.

I am in Pittsburgh. The range offered for a senior level DBA is probably a 50k spread from the highest...

That is killing you.

You have over complicated this. You are trying to get the...

ps_vbdev (10/5/2015)

---

Current table create statement:

CREATE TABLE [dbo].[StockTransaction](

[Id] [nvarchar](128) NOT NULL,

[CreatedDate] [datetimeoffset](7) NULL,

[StockTransactionType] [nvarchar](max) NULL,

[UserId] [nvarchar](max) NULL,

[StockItem_Id] [nvarchar](128) NULL,

[WarehouseLocation_Id] [nvarchar](128) NULL,

[UserLocationId] [nvarchar](128) NULL,

PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

Jack Corbett (10/3/2015)

---

Michael L John (10/2/2015)

---

SQLRNNR (10/1/2015)

---

Ed Wagner (10/1/2015)

---

I'm headed to SQL Saturday Pittsburgh this weekend. I'll be my first visit to this location, but I've heard...

REPLACE(fields_name, '. ', '. ' + CHAR(10))