How can i convert UTC timestamp to GMT in php?
I have a MySQL field that saves the time with UTC_TIMESTAMP() in the INSERT command. When I pull up the record, how can i convert that time t...
I'm thinking of a solution for following query without explicit inner join or subquery:
Table FXR:
FX_Code|FX_Rate|FX_Date
'USD',1.15,'2008-01-01'
'USD',1.2,'2008-02-01'
'EUR',1.1,'2008...
I have two database tables. One has a bunch of account numbers, with what was spent for each account during each period of the year. The other table has a range of accounts that need to be sum...
how to use left outer join when there are multiple tables in from and where clause?
Hi,
I am trying to do a very simple program with a VB.net front end and an Access 2002 back end. I have a list of names and since I am in Ireland many of them have an apostrophe in them. The...
Hi all,
I am wondering if I can use a BETWEEN operator in a SQL statement for the following example?
This is similiar to reserving a hotel room, or something like that:
I want to return...
SQL Server/MS Access
I have two rows of data that I would like to combine to one, example:
[ID] [NAME] [ADDRESS1] [CITY] [ST]
1 Joe 123 Main Street...
I have a file on the server called import.csv. I need to import all of the contents into a mysql called cbacks. I cannot get this code to work. I have included the PHP code as well as a cop...
Hello,
I am trying the following query in SQL 2005 which is generating an error.
UPDATE MailMergeList SET MailMergeList.Address = tbl_DelegatePropertiesSimple.[Field17] FROM MailMergeLis...
Hello,
I have a table that I need to join with two other tables to pull in first and last names. Essentially what I want to do is add two columns to my main table (first and last name) and ...
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'...
I need to combine both these queries to get the max date if they have a entry in either the table. This is part of a much larger query, but I am wondering how to combine these. Thanks
'co...
I am looking to write a query to search my entire database for a value in a known field:
Field Name: UserID
Field Value: 1234567
There are many fields called UserID spread throughout ...
I'm trying to get my table name in a stored procedure be a variable. I've pasted my orginial SP which works fine, but now I have a kink where I need the table name to be access through a varia...
Hi, the date I need to perform a DateAdd on is a string date and needs to be converted. I tried using CAST but recieved an err msg:
Conversion failed when converting datetime from character s...
This is probably a very simple question...
I would like to know how to create a dynamic Stored procedure that will return anything I ask..
like...
CREATE PROCEDURE usp_ReturnTemplated...
I have a mySql database and would like to know how to use a select statement to define a variable and then use that variable in a follow-on statement. I am trying to do this in the stored pro...
I know there is an UPPER and LOWER function in Oracle that can be used to convert text query results to all Upper case or Lower case for symmetry, but is there a function in Microsoft Access (...
I need some SQL Syntax to set the "Must Change" attribute of a Login WITHOUT having to change the current password.
I know this will do it, but it simultaneously changes the password:
ALTE...
I can't figure out the syntax for DROP and CREATE statement in a SQL Server 2005 Stored Procedure.
I want to store the Stored Procedure in another location so that when I EXECUTE it in a ne...
I have a sql 2000 server running as default on port 1433, however I need to change it to a named instance - how do I do this? Help I'm in trouble!!
Cheers
We are trying to find a SQL command that will help us find the table structure of a database. We are talking about 200+ tables on a database. We will be converting from SQL Server to Oracle.
Hello
I hope someone can help me with this query. unfortunately this one's beyond my sql reporting skills!
Please see the attachment for an example of the table I want to report from. ...
Hi,
I'm trying to modify a SQL Query that I use at the moment to pull back all data for last week (Mon - Sun) no matter what day it is, or even one that would retrieve the last 7 days.
A...
Hi experts,
I am trying to place an SQL into an unbound field on my form. The SQL is intended to return the maximum date in a field where moduleID = 1. My SQL is as follows:
=(SELECT ...
