Luis Cazares (7/21/2016)

---

Insert the comma in the ISNULL function.

SELECT DISTINCT STUFF(

(SELECT (ISNULL(', ' + t2.Name,''))

FROM #Temp t2

where t1.ID = t2.ID -- t1.DeliverableITEP = t2.DeliverableITEP AND t1.GeoMarket = t2.GeoMarket AND t1.Segment...

PSB (7/21/2016)

---

Hi,

I need to remove the extra comma before the NameComma field if for the same ID we have a NULL or '' (blank value) as well as ResourceName .

CREATE...

Good question. It is the only logical order to process that statement for me. I guess my brain just works like that or something. I spent quite a bit of...

Eric M Russell (7/20/2016)

---

Within the stored proceure, you could contain most of your T-SQL, or at least the most sensive parts, encrypted in a varbinary(max) variable. The symmetric key could...

Y.B. (7/20/2016)

---

I got a PM from an OP saying simply 'douche bag'. LOL

Granted, I'm having a really bad day and could have responded better...on the other hand at least...

+10000

It is also the only long term maintainable solution.

OP - when you cram multiple values like that...

cbrammer1219 (7/20/2016)

---

--===== Create the test table with

CREATE TABLE #vb

(

[BoxOnPallet] [int] NULL CONSTRAINT [DF_Boxes_BoxOnPallet] DEFAULT (0),

[BuffID] [varchar](50) NOT NULL,

[DateTime] [datetime]...

--URL REMOVED.

This sure looks a LOT like spam. Care to explain why...

ThomasRushton (7/20/2016)

---

I don't think that the reviewers...

There really is no way you can prevent somebody from viewing the code if they have access to the server. The ONLY way you can 100% prevent this is by...

Ray K (7/19/2016)

---

My wife is dying to see The...

Ahh. Did you grant EXECUTE on the scalar function to the user, or better yet the role they belong to? I have seen...

Firemander (7/15/2016)

---

I have an AD account that can see a particular scalar function, but cannot execute it properly. It is supposed to return Current_User. The AD account can run the...

SQLRNNR (7/14/2016)

---

Luis Cazares (7/14/2016)

---

Sean Lange (7/14/2016)

---

Great question. Oddly after answering I decided to see if it really would correctly. I ran the create table and view scripts. Then ran the...

Phil Parkin (7/14/2016)

---

Ray K (7/14/2016)

---

I once had a...