With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
i = 0 ReDim AsgndBibs(0) Set rs = New ADODB.Recordset sql = "SELECT pr.Bib FROM PartRace pr INNER JOIN RaceData rd ON pr.RaceID = rd.RaceID WHERE rd.EventID = " sql = sql & lEventID & " AND pr.Bib IS NOT NULL ORDER BY pr.Bib" rs.Open sql, conn, 1, 2 Do While Not rs.EOF If Not rs(0).Value & "" = "" Then AsgndBibs(i) = rs(0).Value i = i + 1 ReDim Preserve AsgndBibs(i) End If rs.MoveNext Loop rs.Close Set rs = Nothing
|Why i am getting a star, SSMS does not show me any error. Division Error||5||32|
|PROPERCASE SCRIPT IN SQL||3||15|
|Check ALL SP in database make sure there are no errors||17||43|