stretched table - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

stretched table

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-01-11 : 03:59:27

i have this table:

DataName	SizeData_MB	LogName	SizeLog_MB     CreationDate
CTU  	         2.25	        CTU_log	 0.81	         2010-01-10 
CTU	         2.10	        CTU_log	 0.71	         2010-01-09

i want to see like that:

DataName	SizeData_MB	LogName	SizeLog_MB     CreationDate 
CTU  	         2.25	        CTU_log	 0.81	         2010-01-10 
SizeData_MB SizeLog_MB CreationDate_Yesterday
2.10          0.71         2010-01-09

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2010-01-11 : 04:01:39

Hi

You want display only columns?.

-------------------------
[R][A][J]