Database

DECLARE @Value FLOAT =  0.833333333333333;
SELECT CAST(@Value * 100 AS INT);

Declare @X float = 0.833333333333333

SELECT ROUND(@X*100,0)

Member 4006546 wrote:

How to convert Physical XML files into Sqlserver Tables?

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

Xarzu wrote:

Write a SQL query that would return the average salary per city in the format shown below:

select city, avg(salary) from Employee group by city

Xarzu wrote:

How do you use the AVG api function in sql

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

Select City, AVG(Salary) AS Salary
FROM @t
Group By City
Order By City DESC

Select City,Salary From
(
    Select
        Rn = Row_Number() Over(PARTITION BY City Order By (Select 1))
        ,City
        ,AVG(Salary) OVER(PARTITION BY City) AS Salary
    From @t) X
Where X.Rn = 1
Order By City DESC

leketekoa wrote:

oracle database2 is

leketekoa wrote:

nd report back

snowman53 wrote:

I did find Sesame, which seems to have taken over Q&A, but they want $350 for the program

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

snowman53 wrote:

are upset I can't re-install Q&A without the original copies!

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]