Post reply

How to join these two tables

  • October 29, 2015 at 11:32 am

    #309246

    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

  • October 29, 2015 at 11:46 am

    #1836472

    Very simple:

    SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB],

    CPU_Count AS NumberofCPU

    FROM [master].[sys].[dm_os_sys_memory]

    CROSS JOIN sys.dm_os_sys_info

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 29, 2015 at 11:48 am

    #1836474

    Thank you verymuch

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply