patrickmcginnis59 10839 (5/16/2013)

---

is Id unique in both tables? If it isn't, maybe you have a cross join going on because you're joining on it. Now if you have a case...

There's a very good chance that the smart folks here could eliminate the view from the query, if they could see the view definition.

If you are still interested in working it through, there are folks here willing to help.

There are two or three remaining issues with the query;

...

Have you figured out the query issues, Philip?

lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID

This will fail unless you have lyrCompletedRecips...

Cadavre (5/15/2013)

---

ChrisM@Work (5/15/2013)

---

dwain.c (5/15/2013)

---

Sorry to disappoint you guys but I wasn't able to come up with anything.

My gut was telling me an rCTE wouldn't do it and the set-based loop...

dwain.c (5/15/2013)

---

Sorry to disappoint you guys but I wasn't able to come up with anything.

My gut was telling me an rCTE wouldn't do it and the set-based loop I tried...

I'll reiterate what Eugene is saying: you need to know how to collect the value you want from the stored procedure...

Craig - very promising, but try adding these to the sample data set:

UNION ALL

SELECT 2426, 2341 UNION ALL

SELECT 2341, 1200

Abu Dina - are these two additional rows valid data, and...

rohit.kumar.barik (5/12/2013)

---

I am getting file like Text-23.05.13 [dd.mm.yy]

out put should be : 2013 and 23.05

For that i used regular expr: (?<Issue>\d{2}\.\d{2}).(?<Year>\d{2})

The 20 value is not coming before 13. i need...

You can see the effect with SQL Server 2008 R2 (RTM):

SELECT @@VERSION

-- Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30

--...

Quick work, Mark 😉

Thanks...

WITH Resolver AS (

SELECT

[Level] = 1,

[Route] = CAST(RTRIM(t.ColA) AS VARCHAR(25)),

t.ColA, t.ColB, t.ColC, t.ColD, t.ColE, t.ColF

FROM tmpTable t

WHERE ColA = 395

UNION ALL

SELECT

[Level] = r.[Level] +...

syedathariqbal (5/10/2013)

---

Hi All,

Need help on some recursive Data. I would need to get 4 records out of below available If I pass value 395. Since, for 395, COlD (Child of...

rohit.kumar.barik (5/10/2013)

---

Hi All,

I am getting input file below format.

Text-dd.mm.yy.

i need to display as 20yy (year) and mm.dd (Issue) For that i am using regular expr. i am using

'^Text-(?<Issue>\d{2}\.\d{2}).(?<Year>\d{2})\.txt$'

output is...