I would like to convert a date time field to a string . example the string should look like this
08/26/2008 10:30:26
Hi experts,
I want to interrogate an sql table for null values. How do I do that ?
I tried the following
Select * from prrclmas (table) where recalldate (Date field) =' ';
and this does ...
i have the following sql statement:
SELECT POL_EFF_DATE FROM POLICY
The POL_EFF_DATE is being returned in a long date format.
Is there any way to configure the above sql statement to ...
I am trying to create a UDF. My code is attached.
For each row retrieved by the SELECT statement there will be 2 values.
What is the corret syntax to access both retrieved values? Wh...
The below statement works fine but is giving me a result which is a number with 13 decimal points
rounding off is not working for me . It is giving me round requires 2 or 3 arguments error.
...
I'll define a couple of tables to help clarify the question.
MainType
MainTypeID MainTypeName
1 car
2 truck
3 boat
SubType...
hI,
I have the following line of code in a VB6 project
SQLStmt = " INSERT INTO Recipes_West_Table " & _
"Values( " & Form1.Text1.Text & " , " Form1.txtVal1.Text & "," & Label2.Caption...
Hi,
I am working on MSSQL 2000
When I am executing a below query, I am getting an error
Server: Msg 241, Level 16, State 1, Line 29
Syntax error converting datetime from character ...
I have an Oracle SQL query that returns a list of IDs and for each of these IDs I need to loop through them and execute an additional select to get more information about each one of them from...
I'm trying to run a formula in access that I have been using for excell. I'm new to the world of Access so I don't know how to do name extraction in Access. I have the following formulas in ex...
Hi,
What do I need to do to the following Access code to convert to using SQL Server 2005?. I have got so far but am now stuck with the INSERT statement parameters & on adding the current...
I am trying to write a query to insert data into a temporary table if the values in a particular column are null. Can someone help me out with the syntax?
Here is an example to work with: ...
I need to update a table in SQL 2000. I have a table named table1 and a field named staff. I would like use a query to change all the values under staff that has a value of 'bc' to 'vs'. Seems...
Hi all.
I have a table (tblRef) that has a column: Ref_No which is a 4 digit number (first one is 1000) as well as other data, I would to be able to make Ref_No 5 digits instead of 4, is th...
Hello!
About my environment:
I have a hosted web database that I don't have access to other than with classic ASP and an ODBC connection that thankfully gives me both read and write access...
In an access 2003 dbase, I have a field where 'Required' is set to 'Yes'. It should be set to 'No'. This exists in many dbases in the field. I am trying to figure out the ALTER Table statemen...
I'm having the following issue with multiple select statements on the same table.
Trying to get them to return the count produced by each statement as one result.
Select 1
SELECT CO...
Hi experts
How to add totaltime, i have table t_userscoinfo ...
SQL> select totaltime
2 from t_userscoinfo where licenseid=3258 and
3 user_id='test.user1';
TOTALTIME
------...
Need help with the REPLACE command. After running this SELECT :
SELECT CATEGORY, QTY_STK, ACTIVE
FROM ITEMS
WHERE (CATEGORY = '166') AND (QTY_STK = 0) AND (ACTIVE = 'T')
...
I would to use the following example as a sql statement:
SELECT sum(fieldNameX) FROM tablelName WHERE x='1' AND y = '2' ORDER BY fieldNameY LIMIT start, rows
My actual SQL statement is t...
I need to populate a table based on a user filter. In Access i just try to insert all the records the filter returns and allow Access to skip the duplicates. That worls great.
However in...
Trying to run a Stored Procedure once an hour, send the output and a datestamp to a file, but I'm doing something wrong. Using a command (Windows 2k3): "isql -Uuser -Ppswd -Ssvrv -iMyScript >>...
I am running a query that is returning some summary data from a table in Access. I have built the query with the intentions of it driving an Access report, but I want to limit the rows returne...
I have the following code as part of one of my sql statements. I'm trying to account for all values in the field that are not equal to Yes, including Null values. For some reason, if the field...
If I set the default value of a bit field to 0 using the Management Studio, save the change, and then look at the default value, it shows up as ((0)). The same is true for 1 and ((1)). What'...
