Hello. I have a question about UPDATE with INNER JOIN.
UPDATE AliasA
SET AliasA.CarMaker = mstMakerModel.Maker
FROM tblCarAuctionList AS AliasA INNER J...
I'm writing a SQL Query in VB2003 against an MS SQL Server 2000 database. Basically, I"m trying to replicate an Access query (which works) in MS SQL language. The problem is, I can't seem to...
How do I assign a distinct unique number to each field returned. I prefer to do it in sql and not create an index as the table as I do not have sole control of the table. In the below desire...
Is there a way to force a number to display without decimals in SQL Server 2000? If not, a way in crystal reports to do the same? I tried setting the decimal places to 0 in Crystal reports a...
Hi all :)
Just a quick VBA/Excel Question. I'm fairly new to VBA.
I'm currently trying to query an informix database, where as the user would put the specific date range they require in ...
I must update the borr.ssn and coborr.ssn data for 579 records to table BORRDATA. I have seen several Update statements where the update data is coming from another table, but what is the cor...
I am hating the lack of functionality with DSUM in queries right now. I have several reports I need to run based off of information in several tables which are related. I also need to be abl...
I need to insert a date variable that contains formating like so:
12-04-07 13:22:11
Into a SQL Server 2005 table.
Note it is not always that date, that is a sample of the variable as it...
Hello,
I have an issue where i need to format dates in an SQL Server 2005 stored procedure where dates are currently being passed in as 'dd-MM-YYYY hh:mm:ss' and i think that i need them to...
Hello:
I've searched quite a bit and found a few solutions but not anything solid that currently works. What I'm trying to do is basically round the time part to the nearest 30 minute, hou...
Using Crystal Reports XI Developer;
Using MS SQL Server 2000;
public static void Main()
{
Having trouble figuring out the syntax for writing SQL Expression Fields in the Formula Wo...
I have a table. It's a big table. It has lots and lots of columns (about 150).
I'm copying a row from this table to table B. Then I'm updating a column or two and copying it back into the ...
I need to cast from char(14) to int within a SQL statement. Any ideas?
Hi,
I have a query:
select name from Archive_man_live.dbo.syscolumns where id = (select id from Archive_man_live.dbo.sysobjects where name = 'JOBS'
And I want to loop through all of t...
Can anybody help me with a query to select records between today's date and 35 days ago?
How can I combine these to select statements into a single nested SELECT.?
SELECT * FROM NCR_SQL_DATA WHERE [G Date Created] > 39448
SELECT NCR_SQL_DATA.[G Supplier], SUM (NCR_SQL_DATA....
I am looking to create an sql query that basically says 'select firstname & lastname as fullname' and not sure of the exact syntax.
TIA!
How do I incorporate IF THEN ELSE in SQL*Plus? I searched online a bit, and saw reference to using BEGIN/END; around the code to do this. I tried simply declaring a variable at the beginning a...
Dear EE members,
I would like to convert the following sql server query to ms access query:
select grade
= case
when pcode1 in ('A01','A12','A17','A34') then 'P'
when pcode1 in('A08...
I am trying to format a datediff in a paticular format. I have a start date and end date and I am using datediff("D",startdate, enddate) which return only a number of days which is what it was...
I have a data base that has some single quotes in the field EX: new''car. I want to query the data base to locate (and replace) these single quotes but for the life of me can't remember how to...
Working with MS SQL server 2000. Please be very explicit in your responses.
Output I need is a list of tickets generated during any of the options below.
Current week
Last week
Current Mo...
I need to write a Transact SQL query that returns a record set based on a date criteria that returns records less than or equal to current date and no earlier than 12 months prior to current d...
I have text field in my table. text value is in the format "Feb 20, 2007 22:57:36" how do I convert it to a datetime field for processing.
thanks
I need a simple sql that will update a missing date field from the single record (per call id) Call Header to the multiple record (per call id) Call Detail table.
I've been trying:
UPDATE ...
