This has to got to be so simple but I can't get it to work....
I am trying to update 2 fields per record based on the results of a query. I can run the query by itself and it returns the data...
I need an sql which works on MS-SQL and sqlite and does this::
update person SET pers_SecTerr = Comp_SecTerr FROM person join company on Pers_CompanyId = Comp_CompanyId WHERE COALESCE(pers_...
I have a web site with a membership table (id, lastname, firstname, dateregistered, etc.) and a sessions table (membership id, dateloggedin, etc.) which has a record for each date/time a membe...
I'm a total newbie to sql and my developer is not available. I need urgently to add certain fields of the address_book table to the code below, so I can export this information including the m...
I have an mysql table with jobs. This table contains an entry 'insertionDate' which contains the date that a job was insertion.
Now I want to know the amount of jobs that were
- inserted to...
i have 2 tables... client and games.....
in client i have many columns, of which 2 are client id and user id
in games i have many columns , of which one is client id
now i need to g...
I have following query:
select case when parentid like '%-%' then substring(ParentId, 0, charindex('-',ParentId,1)) else parentid end as Parent from assets )
This pulls back all the Pare...
I am doing an assignment for school which involves writing queries. I am done except for I stumped on one question:
Find cid of customers who have ordered exactly the same set of products ...
I have two tables, diploma and degree with columns and data as follows:
Diploma Table Degree Table ...
In Excel I have data as follows and I would like to make this data show up as one row for each of the records utilizing the '=' as the indication of a new row. Some records have 4 lines, some...
The query below works but does not do the required.
i am trying to enter the employee spouse record in the employee table
even though there is no spouse details for the employee, its stil...
I am trying to extract info from two tables
cd_personal_checks
md_cr_pending
I would like to select id, check_no, & check_amount from cd_personal_checks where Status<=2
I would also ...
When using MSMSExpress, can I export my query results to a text file? rather than on the Results frame.
Question1:
I have a query called reports.sql that run smaller queries within, to giv...
I have the following query:
----
SELECT * FROM activities_misc a
left join AttachmentLinks as b on a.act_misc_id = b.Object_id
left join Attachments as c on c.attachment_id = b.attach...
Hello Experts,
I have a seemingly simple problem:
I have an Access database table which is populated via integration with
small-parcel tracking information.
The table has four column...
What does the U in "type = 'U'" mean? What are the other values other than U that might be used?
Thanks
Hi Experts,
I have an Access db table named tblOrders with the following columns: Company (String), RefNo (Integer) and TimeStamp (Date/Time). I would like to insert a new entry/row into th...
This is new message I am seeing. I create a new query in ms access. Do not save it. I am in design view when I create it. I run the query. ONce the datasheet result is up, I use to be able to ...
This is what is returned from a response.write:
UPDATE dbo.RAresults_sent SET (recipients) Values ('francis.robert; Bouchard.Jonathan; lynch.debbie;') WHERE system = 'Penrad_2008'
This is...
Access 2007, Make table qurey.
I am building a table with some data and extra fields that will be filled in with the next query. The field "Credit" I am building and need it to be a curren...
How do I convert a script for SQL Server 2005 to run in SQL Server 2000?
The attached code snippet running in Query Analyzer in SQL 2000 produces several incorrect syntax errors.
I suspect...
Yes,
I have been looking and looking for a while now. I can't seem to find any way to lock a microsoft access mdb file from being used in SQL or even if its possible.
See i have a set o...
Hello programmers. I am getting the following declaration and syntax errors in my SQL script.
1. Can I declare my variables with values for testing. I will be passing the values thru my V...
hi,
I have two tables
Table1 Table2
ID F1 ID F1
1 aa 1 gg
2 bb 3 hh
3 cc 4 oo
4 dd
5 ee ...
Hi All,
I'm brand new to SQL but can usually pick up programming pretty easy so this is frustrating. When I see the example code for this solution, I'm not sure how to interpret it. Excuse m...
