Consider the table T1 it consits
A,2,3,4
consider another table t2 it contain
1,2a,3a,4a
now i need o get the upadted answer
- 3 Answers
- 4111 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreekanthb87
t1
A,2,3,4
t2
1,2a,3a,4a
now union of tw0 table must be
A,1,2,2a,3,3a,4,4a
now how you write the qurey ,the answer should be
A,1,2a,3a,4a
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is the definition for sql server 2000?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
How can we get count of the number of records in a table?
What is the difference between count () and rowcount ()?
How you provide security to cube? : sql server analysis services, ssas
how would you troubleshoot blocking? : Sql server database administration
How do users use Report Builder with SQL Server data sources?
Explain primary key and foreign key constraints?
Define left outer join?
where can you add custom error messages to sql server? : Sql server administration
What are the recovery models in sql server 2000?
What is the importance of three tier architecture?
How do I know if localdb is running?
