Code formatting

Source Link

edited Jul 11, 2019 at 7:14

20.3k
2
19
22

SELECT
    domain_Job.statusCode as "Status Code",
    lookup_JobStatusCode.name as "Status Code Description"
    FROM
    domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
    WHERE
    domain_Job.type = lookup_JobType.id AND
    domain_Job.statusCode > 1 AND
    domain_Job.statusCode = lookup_JobStatusCode.id AND
    domain_Job.id = domain_Job.ParentJobID AND
    domain_Job.state = lookup_JobState.id AND
    domain_Job.clientName = domain_Client.name AND
    DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
    domain_Job.policyName != ''
    GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name

output :

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

Status Code |   Status Code Description
47          | host is unreachable 
7648        | - 
96          | unable to allocate new media for backup, storage unit has none available 
191         | no images were successfully processed 
806         | this mpx group is unjoinable 
47          | host is unreachable 
7648        | - 
156         | snapshot error encountered 
20          | invalid command parameter 
4234        | VMware server login failure

SELECT
    domain_Job.statusCode as "Status Code",
    lookup_JobStatusCode.name as "Status Code Description"
    FROM
    domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
    WHERE
    domain_Job.type = lookup_JobType.id AND
    domain_Job.statusCode > 1 AND
    domain_Job.statusCode = lookup_JobStatusCode.id AND
    domain_Job.id = domain_Job.ParentJobID AND
    domain_Job.state = lookup_JobState.id AND
    domain_Job.clientName = domain_Client.name AND
    DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
    domain_Job.policyName != ''
    GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name

output :

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

SELECT
    domain_Job.statusCode as "Status Code",
    lookup_JobStatusCode.name as "Status Code Description"
    FROM
    domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
    WHERE
    domain_Job.type = lookup_JobType.id AND
    domain_Job.statusCode > 1 AND
    domain_Job.statusCode = lookup_JobStatusCode.id AND
    domain_Job.id = domain_Job.ParentJobID AND
    domain_Job.state = lookup_JobState.id AND
    domain_Job.clientName = domain_Client.name AND
    DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
    domain_Job.policyName != ''
    GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name

output :

Status Code |   Status Code Description
47          | host is unreachable 
7648        | - 
96          | unable to allocate new media for backup, storage unit has none available 
191         | no images were successfully processed 
806         | this mpx group is unjoinable 
47          | host is unreachable 
7648        | - 
156         | snapshot error encountered 
20          | invalid command parameter 
4234        | VMware server login failure

Improved formating

Source Link

edit approved Jul 11, 2019 at 7:08

Asrar Ahmad Ehsan

314
4
15

SELECT
    domain_Job.statusCode as "Status Code",
    lookup_JobStatusCode.name as "Status Code Description"
    FROM
    domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
    WHERE
    domain_Job.type = lookup_JobType.id AND
    domain_Job.statusCode > 1 AND
    domain_Job.statusCode = lookup_JobStatusCode.id AND
    domain_Job.id = domain_Job.ParentJobID AND
    domain_Job.state = lookup_JobState.id AND
    domain_Job.clientName = domain_Client.name AND
    DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
    domain_Job.policyName != ''
    GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name
 
> Blockquote

output :

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

SELECT
domain_Job.statusCode as "Status Code",
lookup_JobStatusCode.name as "Status Code Description"
FROM
domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
WHERE
domain_Job.type = lookup_JobType.id AND
domain_Job.statusCode > 1 AND
domain_Job.statusCode = lookup_JobStatusCode.id AND
domain_Job.id = domain_Job.ParentJobID AND
domain_Job.state = lookup_JobState.id AND
domain_Job.clientName = domain_Client.name AND
DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
domain_Job.policyName != ''
GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name
 
> Blockquote

output :

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

SELECT
    domain_Job.statusCode as "Status Code",
    lookup_JobStatusCode.name as "Status Code Description"
    FROM
    domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
    WHERE
    domain_Job.type = lookup_JobType.id AND
    domain_Job.statusCode > 1 AND
    domain_Job.statusCode = lookup_JobStatusCode.id AND
    domain_Job.id = domain_Job.ParentJobID AND
    domain_Job.state = lookup_JobState.id AND
    domain_Job.clientName = domain_Client.name AND
    DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
    domain_Job.policyName != ''
    GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name

output :

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

Source Link

asked Jul 11, 2019 at 7:06

user3016638

1
1

count number of unique occurrence of each value in 1st or 2nd column and print in 3rd column

SELECT
domain_Job.statusCode as "Status Code",
lookup_JobStatusCode.name as "Status Code Description"
FROM
domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, lookup_JobType, lookup_JobState
WHERE
domain_Job.type = lookup_JobType.id AND
domain_Job.statusCode > 1 AND
domain_Job.statusCode = lookup_JobStatusCode.id AND
domain_Job.id = domain_Job.ParentJobID AND
domain_Job.state = lookup_JobState.id AND
domain_Job.clientName = domain_Client.name AND
DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <=24 AND
domain_Job.policyName != ''
GROUP BY domain_Job.statusCode, lookup_JobStatusCode.name, domain_MasterServer.networkName, lookup_JobType.name, lookup_JobState.name

> Blockquote

output :

Status Code Status Code Description 47 host is unreachable 7648 - 96 unable to allocate new media for backup, storage unit has none available 191 no images were successfully processed 806 this mpx group is unjoinable 47 host is unreachable 7648 - 156 snapshot error encountered 20 invalid command parameter 4234 VMware server login failure

sybase-sql-anywhere

Stack Exchange Network

Return to Question

count number of unique occurrence of each value in 1st or 2nd column and print in 3rd column