If the path has spaces, use double quotes around it.

Once again, J.Celko was able to confuse instead of helping. He's absolutely correct, the MAX() function will be evaluated once within the scope of the query. The problem is that...

andis59 (11/21/2016)

---

MMartin1 (11/21/2016)

---

There is a button in your SSMS window that displays "include actual execution plan" when you hover over it. You push...

drew.allen (11/21/2016)

---

It may have "worked" but it is likely to perform horribly. You should compare it to LEAD/LAG before settling on that as...

Mile

You could try using bcp, which could be called with xp_cmdshell.

Another option is to change the process and use SSIS.

You could also try a cross tabs approach.

SELECT BUSINESS_NAME,

CONTRACT_CATEGORY,

SUM( CASE WHEN NAME = 'RX' THEN VALUE ELSE 0 END) AS RX,

...

Just remove the single quotes.

The OP is asking...

Here's an option on how to get all the orphans and their children.

declare @Sample table (L1 int, L2 int, L3 int, L4 int, ID int, description varchar(100))

Insert Into @Sample...

Eirikur Eiriksson (11/21/2016)

---

Steve Thompson-454462 (11/21/2016)

---

Eirikur Eiriksson (11/20/2016)

---

Quick questions, can you use Table Variable Parameter? How wide are the largest values passed?...

Thank you for the feedback.

If you have some interesting examples, it would be...

h.tobisch (11/18/2016)

---

You say using CHARINDEX or PATINDEX for testing for the occurrence of a character string is a bad idea.

that's why i read this article.

Could not find more of an...

Phil Parkin (11/21/2016)

---

Ed Wagner (11/21/2016)

---

Jeff Moden (11/21/2016)

---

I have to do some more research on it but it may be time for me to get ready to retire.

[font="Arial Black"]Microsoft Replaces Command...

I'm glad that you liked it. Thank you for the feedback.