Permissions confirmed for which user account?

dwilliscp (5/8/2013)

---

Lynn Pettis (5/8/2013)

---

dwilliscp (5/8/2013)

---

...

I have found one other strange thing..

The outer join has data in the columns for details_2, so I do not understand how in the heck it...

If you mean you want to see it in SSMS , then just select it and then click on the value in the results grid - it will open an...

Evil Kraig F (4/29/2013)

---

Because of Mr. Magoo's confusion as to my use case, I want to present an idea of the use case. It's not the one in question...

Evil Kraig F (4/29/2013)

---

D'oh. I misread what you wrote and didn't read the stinkin' code. Not my best moment. That idea I'll definately steal wholeheartedly and without...

Will there always be a path that includes all rows for a particular Ref#?

Evil Kraig F (4/29/2013)

---

Two concerns here. First, the reason the CASE statement isn't in the data generator is because it's supposed to signify different conditions. An example. ...

Having looked closer at the code, I have a couple of suggestions, but only in terms of the test harness - to make things fairer, I think.

Here is the amended...

Some stats for you from my PC

+-----------------------------------------+

¦[highlight="#808080"] TestType [/highlight]¦[highlight="#808080"] AvgLen [/highlight]¦[highlight="#808080"] MaxLen [/highlight]¦[highlight="#808080"] MinLen [/highlight]¦

+--------------+--------+--------+--------¦

¦ Cascade Test ¦ 877 ¦ 1070 ...

The code is too messy to look at : use the IFCode shortcuts on the left when you post code, specifically the code/sql one...

Anyway, I suggest make the description column...

Not an answer about linked servers, more about triggers...

Please don't use a trigger for this, make all your transactions through stored procedures and have that update the Oracle server, or...

Here is a generic example.

You could adjust it for your needs.

declare @x xml;

--== Grab some sample xml ==--

set @x = (select * from sysprocesses for xml auto,elements,type,binary base64);

--== Get a...

Cindy Conway-312336 (4/26/2013)

---

Hi MM,

I was assigning random numbers to each row because I was generating test data. In my case, I was simulating data returned from Market Research Surveys. The...

ChrisM@Work (4/26/2013)

---

I think this is logically the same as the "bombproof" query I posted earlier (even though the plan for my version includes a compute scalar) - the code in...

Personally, for readability and your specific requirement, as long as you can guarantee the data type for PathIDs 30 and 31, then you can use this:

select DataId, PathId, Value

from dbo.TestTable

WHERE...