Sean Lange (12/16/2013)

---

Jeff Moden (12/16/2013)

---

ChrisM@Work (12/16/2013)

---

Jeff Moden (12/13/2013)

---

Sean Lange (12/13/2013)

---

ChrisM@Work (12/13/2013)

---

Sean Lange (12/13/2013)

---

ChrisM@Work (12/13/2013)

---

Sean Lange (12/12/2013)

---

Yes David is on the right path here. A case expression has not bearing on...

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

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

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

SELECT '3-4-vizag' UNION ALL

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

SELECT '3-4-45.old colony' UNION ALL

SELECT '3-4-66/99' UNION...

Without a table name or column names to work with, I made up the names...

SELECT ColAAAA, ColBBBB, ColCCCC, ColDDDD, ColEEEE

FROM Sometables

CROSS APPLY (

SELECT colEEEE UNION ALL

SELECT colFFFF UNION ALL

SELECT colGGGG UNION ALL

SELECT colHHHH

) x

bkshn (12/15/2013)

---

Hello ChrisM@home

let me explain my question again.

I want to do paging with Row_Number on several Join Table.

My temp table fill by executing UserMidlist Procedure

I use code below

DECLARE @RowsPerPage...

yuvipoy (12/15/2013)

---

here i meant scroll is where condition..... for every scroll i will be giving 1000 records...

For the 1st time i will return 1000 records and next time 1001 to...

Jeff Moden (12/13/2013)

---

Sean Lange (12/13/2013)

---

ChrisM@Work (12/13/2013)

---

Sean Lange (12/13/2013)

---

ChrisM@Work (12/13/2013)

---

Sean Lange (12/12/2013)

---

Yes David is on the right path here. A case expression has not bearing on the number of rows returned,...

Greg Edwards-268690 (12/13/2013)

---

So this gets around the limitation that normally turns the outer join into an inner join.

LEFT OUTER JOIN dbo.Email m

ON m.EKey = e.EKey AND m.Next_of_Kin = 'true'

Mostly...

Here you are Greg, I'll leave you to draw your own conclusions.

-- Original query using views reads employee table 5 times, child tables twice

SELECT a.EKey, b.Emp_First, b.Emp_Last, c.Address, d.Phone, e.Email

FROM...

Sean Lange (12/13/2013)

---

ChrisM@Work (12/13/2013)

---

Sean Lange (12/12/2013)

---

Yes David is on the right path here. A case expression has not bearing on the number of rows returned, it merely affects the values...

Greg Edwards-268690 (12/13/2013)

---

Chris -

I agree with a lot of your Why's. See this all the time.

If you could look at this, run the view for next of kin info, and...

pietlinden (12/12/2013)

---

Your table is really structured like that? What happens if you get more software packages? Does the table structure change? IF y

I think storing information using this...

If it's an ETL job then you'd probably call it a data load; incremental, if you're not truncating the target table beforehand.

Sean Lange (12/12/2013)

---

Yes David is on the right path here. A case expression has not bearing on the number of rows returned, it merely affects the values for a single...