Hi, appreciate if you can spend few minutes to analyze the problem below and shed some lights. Thanks
I would like to Sum up MTD Value and separate by employee ID. I've used SUM(MTD_Value) and Group By Employee_ID but is not work.
Dim connetionString As String Dim sqlCnn As SqlConnection Dim sqlCmd As SqlCommand Dim sql As String connetionString = "data source=infinitySH-PC; initial catalog=Human_Resource_Management;" & "integrated security=true" sql = "Select Sum(MTD_Value) from PCB_Est Group by Employee_ID" sqlCnn = New SqlConnection(connetionString) sqlCnn.Open() sqlCmd = New SqlCommand(sql, sqlCnn) Dim sqlReader As SqlDataReader = sqlCmd.ExecuteReader() Dim X As Decimal While sqlReader.Read() X = sqlReader.GetValues(sqlReader.Item(20)) End While Response.Write(X)
Please refer attached document
Employee ID | MTD_Value
ABC12345 | 30.3
ABC12343 | 50.5