Very interesting queries were posted here

Here is another one

select * from

(

select n1.name,n1.end_dt start_unemp

 , (select min(n2.start_dt) from quiz1 n2 where N1.NAME=n2.name and n2.start_dt>n1.start_dt)  End_unemp

from quiz1 n1

) kk

where start_unemp<>end_unemp

So, that is. May be SQLServer 2005 will give us to possibility to query the creation date of all objects in Db

Thanks

Larry

The MODEL database can be a solution.

Create all procedures and tables on it.

All new created databases will have all tables and SPs

If tables are populated in model they will...

You also can try:

select id ,

max(case comp when '1' then value else ' ' end) '1',

max(case comp when '2' then value else ' ' end) '2',

max(case comp when '3' then...

quote:

---

If I have a table like this:

ID Comp Value

---------------------

1 1...