SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB]
CPU_Count AS NumberofCPU FROM [master].[sys].[dm_os_sys_memory]
select * from sys.dm_os_sys_info
Here i want to join the second query to fisrt and need out put of Total_Physical Memory and Cpu_count information