Simple SQL help

[alpha05]

SELECT COUNT(ID) AS TotalSupportIsses
FROM jirauser.jiraissue
WHERE (issuetype = '5') AND (issuestatus <> '6')

SELECT COUNT(ID) AS TotalCustomers
FROM jirauser.project
WHERE (pname LIKE 'Support%') AND (pname <> 'Support: Internal')

I need to divide the value of the first by the value of the second. So the first query returns 5 and the second query returns 10 so I need my stored proc to do 5/10.

[zierde01]

Try this:

DECLARE @CountID1 FLOAT
DECLARE @CountID2 FLOAT
DECLARE @Answer FLOAT

SELECT @CountID1=COUNT(ID)
FROM jirauser.jiraissue
WHERE (issuetype = '5') AND (issuestatus <> '6')

SELECT @CountID2=COUNT(ID)
FROM jirauser.project
WHERE (pname LIKE 'Support%') AND (pname <> 'Support: Internal')

SET @Answer=@CountID1/@CountID2

PRINT @Answer