You're welcome - but do think about Jeff's point. In case you're wondering, there is a solution for an...

;WITH SequencedData AS (

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY state, region, level ORDER BY (SELECT NULL)) FROM #temp_f)

SELECT

state,

region,

username_1 = MAX(CASE WHEN level = 1 THEN username ELSE...

A sample data set for folks here to run queries against would be gratefully accepted too! If you're not sure how to do this, click on...

Can you set up the ddl for your base table please, as Sean suggested? This allows folks to work on your problem straight away. You do the easy bits, we...

;WITH MyAddresses (HouseNo) AS ( -- meagre sample data set

SELECT '2/4' UNION ALL

SELECT '2-4' UNION ALL

SELECT '3-1-92/4 hyd' UNION ALL

SELECT '3-1-99/7' UNION ALL

SELECT '3-1-900' UNION ALL

SELECT '3-4-' UNION ALL

SELECT...

shashianireddy (12/20/2013)

---

k ..thanku

if house no like...

SELECT '3-4-53 . HYDERABAD' UNION ALL

SELECT '3-400-199/1.ASVV' UNION ALL

SELECT '3-49-vizag' UNION ALL

SELECT '3-53-22,nagar' UNION ALL

SELECT '4-5-1300.old colony' UNION ALL

SELECT '4-500-120' UNION ALL

SELECT '3-4-' UNION...

Hi Mark, this looks like a straightforward CROSSTAB query. Have a quick read of this article [/url]which will show you how to set up a few rows of sample data....

Not so fast! It won't work for all cases. I recommend you use the "stare and compare" method rigorously...

uzwa ul haque (12/19/2013)

---

The Attendance System devices are a separate software. The data in there table is just like this. Some people do time-in and no time outs. I have...

Best for the business or best for the user?

bharat sethi (12/18/2013)

---

Hi!

Please assist that "Order By" clause is necessary in this query and is there any wrong outcome if we do not use this Order by clause? Please share...

Here's an alternative query form which reduces the row count from the permanent table:

UPDATE t1 SET

test = RTRIM(x.xyz_test)

FROM #tmp_sp_abc t1

CROSS APPLY (

SELECT TOP 1 xyz_test

FROM t_h_bg_pc_it...

bharat sethi (12/18/2013)

---

Hi!

First of all can't separate the OR. and tried this but, getting diff. in output of 5417 rows (may be due to some rows have values in both...

twin.devil (12/16/2013)

---

ChrisM@home (12/15/2013)

---

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...

mister.magoo (12/17/2013)

---

Good day Threadizens 🙂

I have written an article (my first) on how to get help with SSRS reports.

It was inspired by Jeff's classic "Forum Etiquette: How to post data/code...