L' Eomot Inversé (3/28/2013)

---

BrainDonor (3/28/2013)

---

"I'm a DBA, it turns out"

How do you suddenly discover that you're...

Just another reason to use table aliases in your code, Microsoft has deprecrated 3- and 4-part naming conventions in the select list. These will not be supported in a...

Add on ORDER BY where you concatenate your values:

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

CREATE TABLE #testEnvironment ([Sample_ID] INT, [Rep_ID] INT, [Result] VARCHAR(20))

INSERT INTO #testEnvironment

SELECT 1, 1, 'O152' UNION...

SQLRNNR (3/28/2013)

---

Lowell (3/28/2013)

---

BrainDonor (3/28/2013)

---

"I'm a DBA, it turns out"

How do you suddenly discover that you're a...

You say you found the solution, forum etiquette would have you share your solution for others.

If you have...

asita (3/27/2013)

---

Hi Kevin,

thank you veru much for your immediate response, could you please see the attached expected result,

if possible please get the results like that

i greatful to your help

thanks alot

best...

Your DBA can create a signed stored procedure that runs with necessary permissions to allow the procedure to return to the user that data requested. I don't have the...

What to make of this?

May not be what I was thinking. Good.

I have a possible answer, but I'm not going to give it to just anyone. If you...

Are you the DBA? If not, I would talk to your DBA.

The two T-SQL functions, DelimitedSplit8K and DelimitedSplitN4K, that are attached to the article I referred you to are optimized to split varchar(8000) and nvarchar(4000) strings.

I would read the article and...

Does this mean you don't see all the users when you run the query?

Nope, sorry or I would.

Probably should have kept this with the other thread as it is related, but I have to ask; who is going to be running this procedure, normal users or DBAs?