I am strying to cast an integer to a string while adding fields together, but my syntax whatever I change to never seems to work. I am tryign to add in s.streintAsgnstr which I have to sum f...
This is one of those days I just can't wrap my head around the formula. It was one of the quick ones that I had in Algebra I that I just can't remember.
I have the total amt and the percent...
Mental block with this one. I have the following query (which doesn't work!)
Select Distinct
Contact_ID,
Company_name,
Town,
County,
Industry_description,
Main_activity,
No_ees_...
I am getting this error 1054 - Unknown column 'p.manufacturers_id' in 'on clause' I thought I had updated everything to work with MySQL5 but this one issue is left and I can't figure it out
Hi,
Below is 2 views, How to join all 4 tables in to one view?
Hi
I have the following code which returns me a whole number. Can anyone tell me how would I amend for it to retun a whole number and 2 decimal places?
Thnaks,
jonathanr
declare @...
Hello,
I'm using Paradox 9. I have two tables - "records.db" and "keys.db".
I'm trying to select records from records.db where there is a matching key in key.db
Something similar to:...
I'd like some help determining how to retrieve records from an historical table that show that an indicator has been changed at any point throughout the specific user's history.
Some exampl...
Trying to use this sub select in my main select statement. I know this isn't the correct syntax from testing it but this is what I want it to do below. There are many different payments with...
Hi,
I am sometimes required to delete large amount of data from a table, like 2,000,000 records. Giving a single command like delete * from... takes hours to purge the data.
Do you thin...
Hi,
I have an classic asp page and I am trying to find out how you add inverted commas into the following sql syntax:-
cQueryString = "EXEC Maintenance_EditDowntimeCard " & _
" @...
Greetings Experts,
I need some help with a query that takes one column, divides it by another and multiplies the result by 100 (ie percentage). I need to account for scenarios where there wi...
Can anyone tell me where im going wrong with this SP firstly it seems ok but when i try and use it i get the following error
"Syntax error converting the nvarchar value 'OUTPUT' to a column...
I have a Search page built on my site to search an access table.
The search works fine, but I need to provide a method for the users to Clear the results via a button, and allow a new search....
I have a query (see fig 1 in attachment) that returns a table with various data from a call centre ticketing system.
The assignee column returns the id of the person that the call has been as...
Looking at the code posted below, I would like to combine columms where the user2ent are the same with the exception of the last digit.
Example:
bsatterfield and bsatterfield1 I would li...
I have the following query which outputs a person's name, the itemsid owned by that person, and the total savings on that particular item. I want to be able to modify this query so that if th...
I have a sql server 2005 database that is maintained through Access 2003. I am writing a program in visual studio 2005 in VB.net to show the borrower's first name and last name in a drop down ...
Hi Experts
I'm having some trouble getting a recordcount and moving to the first record on the following code. Can anyone see the error to help me get
a/ the record count .
b/ move to ...
I have a locked textbox on a form, for recording notes about a record. This is bound to a table. (tblNotes)
There is a second textbox on the form, where the user may enter their new note, th...
Using VB 6, trying to pass a variable to a SQL Statement. Recieve the following error message. " Data type mismatch in criteria expression". The problem is in the Where Statement using the ...
Hi,
I have two tables; let's say Table 1" and "Table 2".
Table 1 Table 2
------------ --------------
Field 1 Field 1
Field 2...
I am using echo command in sql 2000 for writing some contents to a text file. I want to Insert an empty line in between the contents. Is there a way to insert a empty line using echo command?
I have the attached code which returns data related to a studynumber ['%" & Session("findme") & "%'] and date range ['" & Session("startdate") & "' and '" & Session("enddate") & "'].
Include...
Hi,
having two tables A and B.
A contains month end observations and looks like:
DATE CRIT1 CRIT2 X Y
12/31/1990 2/15/1991 ...
