I need to Execute the Update Query (===>) in the attached code snippet. The query will update my SQLDB refered to in the connection string above it.
Question: What is the proper command / ...
Team,
I have 2 columns of data in a table. Column A contains dates and column B also contains dates. What I would like to do is output a third column which tells me the latest of the 2 date...
i want to exclude and n/a or blank values in this statement, possible?
thanks
I can't see the problem
Incorrect syntax near '('.
IF NOT EXISTS (SELECT iPrerCourID FROM Cla_Prere (nolock) WHERE iClsID = 9859 AND iPrerCourID = 948)
BEGIN
INSERT INTO [MyDB].[dbo]....
I have a query that I want to count all the dates less than a month old and then a query that I want to count all the dates in the last calendar year
I am trying to run this query on a SQL Server 2000 DB but I get the error message
"Line 1: Incorrect syntax near 'LOGIN'.
Incorrect syntax near the keyword 'USER'."
Can someone please ex...
In SQL I have string similar to
6,6,15,28,15,28,28,28,28,28,28,28,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,27,27,27,27,27,23,55,98,98,98,98,98,98,98,98,61,23,23,24,24,24,24
I...
Hi Guys
Can you find anything wrong with this query, it says invalid column name on all the columns, I am tryinf to display the result in a gridview
Changing from MYSQL to MS SQL on our ASP pages. We can query the database and get all fields with data. However when inserting the value from the same query to the ASP page only some data is d...
balanceborow.amout*.02 AS Interrest the out put is 800.2000 or 450.0200 how can I set the out put is interger 800.20 should be 801 or 450.0200 should be 451
SELECT balance...
I have the following
SELECT PCNS_Staff_NO, sum(PCNS_STAFF_SR_ALLOCATION_TOTAL_HOURS)/
IsNull(NullIf(sum(DateDiff(dd,PCNS_STAFF_SR_ALLOCATION_START_DATE,PCNS_STAFF_SR_ALLOCAT...
This query runs perfectly in .net Query Builder but generates a syntax error in sql server. Syntax error near the keyword GROUP. It is referring to the last GROUP in the query. What am I missing?
I have a table called Applications. I want to do an insert into the following fields:
Appfname, AppLname, Apposition,Appemail. How do I write the SQL query to do this?
Hi - I have the following query which gives me an Average review score for each Product ID:
SELECT Dates.Week, [All Reviews Report].[Product ID], Count([All Reviews Report].[Product ID]) AS...
I have a query like the one below. I would normally use Quote_ID column in the results as a row number in the results.
SELECT Quote_ID, Project_ID
FROM dbo.job_costing_quotes
...
I have the following query in Oracle. But it runs very slow ( for ever). what is the problem and how to fix it? It's the query problem? How to improve it so that It runs faster.
SELECT /* +...
Hi,
I have the following sql code in C# 2005 -
System.Data.SqlClient.SqlDataAdapter da2 = new System.Data.SqlClient.SqlDataAdapter("SELECT m.fat, m.chest, m.waist, m.neck, ...
Hello Experts,
I have very little knowledge of SQL, and I'm hopelessly over my head with this query. So if I can get the actual query I'd be very grateful. I don't know how to ask this ex...
This is a very long query but I need to show the entire query to make sure you see all the detail.
With query as it is now, I have three records returns. Each record is unique by Source.Ma...
Hello, what is the date syntax for running a query that returns records from before the last 3 months, i.e.
SELECT * FROM myTable WHERE TheDate >= (NOW-3 MONTHS)
Of course there would b...
I have an access query that does some math to a couple of expressions. Some of the fields in this column will be null. I want to turn those null fields into zero. Is there a way to do this?...
I have an interesting query I am trying to put together and I am not sure if it can be done in one sql statement or not. Below is some sample data.
ID1 ID2 ProductID
1 ...
I have a Search form that is basic and works ok but the glitch is I can't search simultaneously on two memo fields.
Here's my filter:
Me.Filter = "Title-Memo & Descr-Memo & Category &...
Hi Guys
I have this php script
$select = "
SELECT
ID,
IPLong
FROM
Tracker
";
$rs = $conn->execute($select);
if(!$rs->EOF){
while(!$rs->EOF){
$select = "
select...
Hello, I have three sql select statments I would like to combine into one. I have created a statment that works but I am not sure if it is a good solution performance wise. Is there a better...
