Lynn Pettis (8/5/2009)

---

You should still explicitly name the columns in the SELECT clause. Not that it may cause problems, it is just that is, for many of us, a...

Lynn Pettis (8/4/2009)

---

Please tell me you aren't using the * in the SELECT clause in your production code. You really should explicitly declare the columns you are returning in...

I'm referring to you, sorry for my mistake.:-)

Michael Valentine Jones (8/4/2009)

---

The...

It's working! Thanks a lot, Lynn Pettis and Allen 😀

Lynn Pettis (8/3/2009)

---

After first fixing the missing comma after field_c in your code, you will get the following error:

Msg 207, Level 16, State 1, Line 11

Invalid column name 'rowNum'.

You can't...

Will try on your approach, thanks again 😀

I'm just taking some fields from each table, the actual one has a very different structures.

I could'nt use UNION ALL as it may retrieve duplicated records and I want to...

I'm just taking some fields from each table, the actual one has a very different structures.

I could'nt use UNION ALL as it may retrieve duplicated records and I want to...

Hi Goldie,

My count function is almost the same as the SELECT function without the ROW NUMBER().

Finally I came out with some samples, kindly advise.

-- * Employee Table --

DECLARE @Employee TABLE

(

EmpID...

Hi Goldie,

If just create some table variables with some data, how could I simulate the situation without the same structure? Sorry, just couldn't find a way to create the sample...

Thanks, just found that by setting Results to Text will do. 😀

I wanted the result in text format, and with some additional text also.

Thanks for your advice, David.

Hi Goldie,

Sorry, I was trying to create some sample data with similar conditions but no luck, the structure is too complicated.

1. I have to use UNION...

Hi Florian, thanks for your advice. My mind was thinking about using the procedural approach to solve the problem. Now, I learned that SQL is made for set-based operations.

Thanks again...

Let's take this as example, my application has tables to store Country, State, City, Province. And each table has a fk to the other table.

Example

1. CountryPK will...