Again, have you tried?

Someday you will wish you had ordered by column name instead of ordinal position. All you gain by ordinal position is ambiguity.

select SomeColumn from MyTable

union all

select...

daveriya (11/8/2011)

---

no my prob is

select order 2, book_id,table_name,account_id,account_name

from book,account

where book.id = account.id

union all

select order 1,column1,column2

from table1,table2

where-----

union all

select order3,column1,column2

from table1,table2

where-----

union all

select order4,column1,column2

from table1,table2

where-----

in this query,every select has order column,mens if i...

daveriya (11/8/2011)

---

no.i want to use order by 1,5,do i need to include it in every select statement. i dotn know how to use it,coz every select stm has order by...

It is certainly easier to read and if you change the column order at some point your order...

Are you trying to store calculated fields for things like average across all the records of a given type? This is exactly the reason NOT to store calculated values. You...

Do you always want it in the same order? If so, just add an order by to your query.

FWIW, You should order by column name and not ordinal position....

He posted his function at the top of page 2.

Why do you not want to use with Linked Servers? This is what they are designed to do.

I don't think the timeout is happening where you think it is. You are getting a connection timeout? That means that your sql is taking longer to complete than the...

Not exactly sure what the issue is here but your update looks pretty suspect to me. You have created a cross join between the two tables. You should use a...

Can you put together some ddl, sample data (insert statements) and desired output based on your sample data?

Brandie Tarvin (11/8/2011)

---

Sean Lange (11/7/2011)

---

Brandie Tarvin (11/7/2011)

---

Sean Lange (11/4/2011)

---

Sounds like you need the cascading delete and an insert trigger on the master. In your trigger just insert into the peer...

Jeff Moden (11/7/2011)

---

Sean Lange (11/7/2011)

---

ryvlad (11/7/2011)

---

hi I found this function somewhere on web and it have been very helpful 🙂

just run it on your DB and you can always...

ryvlad (11/7/2011)

---

hi I found this function somewhere on web and it have been very helpful 🙂

just run it on your DB and you can always reference it from anywhere...

LOL. No worries. I...