Search results for query: *

This is probably a simple question but I cant figure it out. I am trying to shorten some code by using a Do Loop. What I have are Fields names (Access DB) that are named Q1-Q20 and instead of writing the same code 20 times I am hoping to do something like this. Dim rstIn As New...

I am writing a case statement and need to add a value if the row count is 0 ...Here is my code update A Set SDBACHE_STLEV = CASE When (b.Hours_Earned) Between 0 and 27.990 Then '02' When (b.Hours_Earned) @@RowCount = 0 Then '02' When (b.Hours_Earned) Between 28 and 57.990 Then '03' When...

This may not post as a good question because it may be to vague..but I will give it a shot... I am trying to figure out some code that is in PL/SQL...In some of the sql statements that use Select 'X' from dual where fieldname = :ID what is Select X? I have tried this out...but it returns...

I am trying to update a table (EWS) by using a case statement. I am able to run this select statement select A.EWS_ID, A.EWS_Level, b.Hours_hours_earned, "NEW STUFF" = CASE When (b.Hours_hours_earned) Between 0 and 27.990 Then '01' When (b.Hours_hours_earned) Between 28 and 57.990 Then '02'...

I am trying to convert decimal numbers into a number without decimals… Sample Data Now Needs to Be 23.00 2300 68.67 6867 42.36 4236 All the decimals are two places. I have used this sql statement to view the data select table_hours, cast((table_hours * 100) as int) AS NewHours From...

What I am trying to do is get the Max Activity Date and the min admit date. Here is the Data... ID Effect Date Admit Date Activity Date 17189 199603 199201 1997-04-14 17189 200303 200303 2003-02-13 17189 200302 200302 2003-02-13 17189 199503 199201 1995-11-15 17189 199201 199201 1995-11-15...

I am inserting a number into a database and I want the number to display as 003250...but in the database it is just 3250. Is there anyway to make this appear correctly without changing the data type to varchar or something else? Thanks

Hello everyone…I have another sql question. I am checking a database of everyone that has a previous name. For example, change of name after marriage. The table has the following columns. ID FirstName LastName Change_Indicator Activity_Date 1 Billy Bob NULL...

I am trying to update the WO_Dates table with a date that is provided by a textbox named freezedate. Below is the code strSQL = "Update WorkOrder INNER JOIN WO_Dates ON WorkOrder.WorkOrder_ID = WO_Dates.WorkOrder_ID SET WO_Dates.WO_AlertDate=" & freezeDate & " WHERE WorkOrder.Pertaining =" &...

I need to pull out data from sql and some of the data will need to be change. I am going to pull the data out first using DTS packages and then i want to write some code to change the rest of the data. I have seen some If statements mentioned in this forum...but are these stored procedures or...

I am designing a survey and once the user leaves the first page...I do not want them to be able to go back and resubmit the form again. I have disabled the back button by using the following code <script> history.forward(); </script> Since the user has to login, I have it coded in the...

I am trying to validate if a combo box has been selected.. Here is the code <script type="text/javascript"> function validate_required(field,alerttxt) { with (field) { if (value=="[Select]") {alert(alerttxt);return false} else {return true} } } function validate_form(thisform) { with...

I posted this message earlier but was unable to log back in b/c of a registration problem. Not sure exactly what happened there. But I noticed that dotnet had responded but I was unable to view the response. So here it goes again… I have some java script code that alerts the user if the did...