Search results for query: *

Hello, I'm trying to get a total of how many minutes an assigment too to be completed userid carlosh Assignment 12345 start_dtim 2010-05-23 16:02:17 end_dtim 2010-05-23 16:27:53 userid emilyc Assignment 12346 start_dtim 2010-05-23...

HI, I'm trying to insert multiple records in one statemtn to my my informix db. I tried the following insert to [table] (col1,col2,col3) values ('value1','name1'),('value2','name2') but it dit nod work I also tried union insert to [table] (col1,col2,col3) select ('value1','name1') union...

I'm trying to use CASE in the group by clause and I'm having a bit of a problem. for example SELECT CASE WHEN Order_Date IS NULL THEN 'Unknown' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 0 AND 6 THEN 'Recent' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 6 AND 18 THEN...

Hi, I'm trying to compare 2 sets of data from the same table. for example status Recd# Date COM 1000 08/20/2008 COM 1001 08/20/2008 AVL 1002 08/20/2008 AVL 1000 08/20/2008 AVL 1001 08/20/2008 The result i'm looking for is records with AVL status that are not in COM status...

I want to union to different table from two different datasources one is an informix db and the other an Sql Express db. The two tables are not the same but they share common columns. any ideas will be greeeeeat! thank you very much!

Hi, I'm creating a small single data entry form for a handheld. I have a "staging" textbox where people enters data and the stagingtextbox then sends to other textboxes depending on the data. The problem i'm having is that because the handheld is touchscreen if the user touches the form...

Hello, I have a small asp.net formview with 4 textboxes where the user is using a scanner to scan barcodes. What I want to do is to have a html Scan Textbox outside the formview control where the user scans the barcode and if the data starts with the letter "T" then copy that value to the...