Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write quarie

display order by houseno

relate to...

Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write quarie

display order by houseno

relate to...

Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write...

There's quite a lot wrong with your statement. Here's a brief analysis:

declare @string nvarchar(MAX)

declare ...

SELECT x.*

FROM TableA

CROSS APPLY (

SELECT cust, SUBSTRING(wptext, 1, 80), 1 UNION ALL

SELECT cust, SUBSTRING(wptext, 81, 80), 2 UNION ALL

SELECT cust, SUBSTRING(wptext, 161, 80), 3 UNION ALL

SELECT cust,...

shashianireddy (12/7/2013)

---

the first method is ok but ..... it works only if housenumber is integer only ...

it shows error when housenumber mixed wit varchar .............

plz write the code...

I'll second that - and give credit where...

elham_azizi_62 (11/5/2013)

---

hello all.

I need to use nested cursor for 5000 record,but it doesn't work correctly and stoped.what is the best way instead of using cursor when we have lots of...

Fix your join:

left join VoucherType vt on vt.VoucherTypeCode = vt.VoucherTypeCode

Comment out the date filter and rerun the query.

Thanks Dwain for another informative and well-written article. It wouldn't surprise me if the discussion provoked a significant rewrite with more use cases, based on posts so far.

There's unlikely to be much difference.

Sean Pearce (10/10/2013)

---

/* ON THE SERVER phlsql */

CREATE PROCEDURE dbo.FetchData

AS

SELECT sam_batch, SUBSTRING(sam_phonenumber, 4, 9) AS phone

FROM capabilities.dbo.aww_sample

WHERE sam_batch BETWEEN 437 AND 449;

GO

/* ON THE SERVER p42 */

CREATE TABLE #Results (sam_batch...

paulcauchon (9/13/2013)

---

ChrisM@Work (9/13/2013)

---

...

Paul - if you order the output by AutoID, it all becomes clear. There's a description of how the method works here[/url]. The inventor, as far as I...

paulcauchon (9/12/2013)

---

I see the hitch up here...you need to see the min date and max date from each of the consecutive color/ID group pairings.

Originally, we had been treating the grouping...

Not really, it's too vague....