Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SadafKhan85
Starting Member
8 Posts |
 Posted - 2013-07-03 : 07:46:04
|
| create view MyView as ( select row_number() over ( order by col1) as ID, col1 from ( Select col1 From Table1 Union All Select col1 From Table2 ) a ) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-03 : 08:37:10
|
| hmm...whats the purpose of view for just that? Whats the problem in using row_number logic inline in your final select?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Creating dummy Identity