Advertisement

1 - 3 of 3 containing alltags:("SQL - SMS") (0.001 seconds)
 
MS System Center 2
SQL Server 2005 2
MS SQL Server 2
PL / SQL 1
SQL Query Syntax 1
 
 
 
error: Only one expression can be specified in the select...
Tags: Microsoft, SQL - SMS
I get the error "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS" when I execute this code in SMS: select v_R_System.Name0 from v_R_System w...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Systems_Management_S...
Zones: Microsoft SMS, MS SQL ServerDate Answered: 06/11/2008 Grade: A Views: 107
SQL Query for SMS
Tags: SQL, SMS, Query
I want to run a report in SMS to display PC Name, model, processor, memory, and service tag from Dell.  I found the following SQL query, but it errors out; SELECT DISTINCT Computer_System_DATA.N...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23852152.html
Zones: MS SQL Server, SQL Server 2005, Micros...Date Answered: 11/10/2008 Grade: A Views: 4
How do I join these two working SQL queries?
Tags: Microsoft, SMS, 2004, SQL Reporting, SQL, SQL, SMS reporting, joining queries
I have two working, but seperate, sql queries that I want to combine and save as a custome report to run from within SMS. The desired output of the report is to return all computers with the speci...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23741203.html
Zones: SQL Syntax, PL / SQL, SQL Server 2005Date Answered: 09/17/2008 Grade: A Views: 4
  • 1