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'...
Can someone please help me to get this query to work.
SQL 2000 standard
Goal.
Display the amount of days an invoice is overdue by.
If it is not overdue then leave it blank.
SELECT i...
Hi all
i have the following stored procedure but it doesnt return any value for me and seems to loop indefinately
ALTER PROCEDURE [dbo].[spGetRootId]
@menuid int,
@parentid int = NU...
Greetings Experts,
I need help writing a query to remove leading zeroes and then perform a join. Let me further explain.
I have 2 tables
Table1
Site
015
USMACH01
Table2
Sit...
Background: I have developed a SQL query that retrieves 401k info from employee payroll check transactions. One requirement or the query is to output 5 fields in the query that represent up t...
Dear Experts,
Good day. I am looking for some assistance in building a query. I have a Access 2007 Database having a just one table, namely "CDR". The Field structure of the Table is as fol...
I need to import multiple records from an external database into an MS Access table. I can't seem to come up with the right syntax for multiple records.
This works for a single record:
IN...
I have 2 questions:
1> I have a datetime field in my db which somehow has the year 2020 instead of 2008. I need a way of changing 2020 to 2008. Dates show as '28/05/2020' format.
2> I have...
I am attempting to change a field (column) name in a table in access 2000 mdb from VB6.0 program using the sql alter command.
I am getting the following error message "Syntax error in ALTER...
Greetings Experts,
I have previously opened this question before and closed it thinking it was working. Apparently it isnt.
Here is the orginal question;
http://www.experts-exchange.c...
We have an invoice table (SOP10100). Every weekday I'm running an update statement to modify the DOCDATE and INVODATE fields to a previous date (If Monday, I make it Friday's date, otherwise ...
What's the correct syntax for the following WHERE clause?
WHERE [EventDate] >= '12-1-2008'
Currently I have two timestamp in my Firebird database - TxDate and TxTime.
1) I found that when I update this TxTime with my TDateTimePicker.Time value, I saw it is stored as "1/1/1900 2:3...
I have a database table called tk_Tracking with the following columns and data:
OrderNumber TrackingNum Status
246880 1Z258000AC1 Y
246801 ...
Hi Experts,
I would like to select all records base on yesterday's date. But I only want yesterday's records.
select * from table
where timevalue = getdate()-1
getdate() might not ...
Is there an existing function in DB2 SQL, to convert date format from '10/24/2008' to '2008-10-24'
AND
is there an equivalent to DATEPART('yyyy', MyDate) in DB2 SQL
Thanks
All of the hibernate examples I have seen/used so far look like this:
public List<String> getStuffFromDataBase(String condition)
{
return hibernateTemplate.executeFind(new HibernateCall...
There is a table with a Last Name field. There are several people with hyphenated last names.
I need to design a query that only displays only the characters after the hyphen.
Example...
i have 6 columns in the table.
i have to write a sql query to copy data of 1 columns in the another column of the database.any help appreciated.. am using mysql
I need to write a stored procedure that will check the first 5 and last 6 charcters of a string. If the first 5 characters = '<div>' and the last 6 = '</div>' i need to remove them from the s...
Ok I am having a bit of a problem here. I have the following syntax that does not work:
select ponumber, postatus, potype, user2ent, docdate, vendorid, vendname, buyerid from pop10100
wh...
Hi, I have the following string variable that are concatenated in an SQL statement. However, the result is not what I expected, as it does not return records from database.
insertList = "fi...
I am creating a table and adding some constraints in SQL Server 2005. To simplify greatly:
I create Column A, and then Column B
Column A can only be one of two values, A or B, so...
C...
Hello,
I have a table called AdHoc which contains my main data and I have a 2nd table with just account numbers. I want to delete the accounts from Adhoc Table which are in the 2nd Table. I h...
I have this script:
IF A = 1 THEN
CREATE TRIGGER ABC ON TABLE DEF ...
ELSE
CREATE TRIGGER ABD ON TABLE DEF ...
END IF;
It is an install script run from SQLPLus and off course do...
