Hi all,
Here's what I want to do:
UPDATE tablename
SET column = 0
WHERE ID = ???
I want to specify a range of numbers (like 100-200) and increment it by 2.
So, 100, 102,104etc would only be updated and the rest wouldn't.
Any ideas?
Thanks,
T
Can someone assist me with a quick SQL statement.
I have a table with 3 columns: A, B, C (A would be the primary key)
I need to swap the values in column B with the values in column C and vice versa.
TIA,
Mike
~|
Archiv
I need to do this and don't know where to start.
Compare part of a part number in one table to another table. The part numbers look
like this.
12345.123
12345.234
12345.654
02nt911dc.123
02nt911dc.054
02thq5
02thq7
The part before the dot is all I want to use to compare to the other table whic
Howdy all. I have a client that wants me to build him a reporting
section based on the order month. I know how to do a SQL to get like
the total of orders for a particular customer.
SELECT Cust_ID, SUM(Order_Total) AS Total
FROM Orders
GROUP BY Cust_ID
But, is there a way to group on the month
here's what i'm doing
delete from class_registration
where users_id='123123'
and class_id='4242424'
here's what the table looks like
nameusers_idclass_id
gavin 123123 4242424
gavin 123123 4242424
gavin 123123 4242424
gavin 123123 4242424
what i want to do is delete only
Hi List,
I am Learning SQL by trial and error. So far so good -- Until today.
I have a feedback form that captures comments. Currently I am using the
TEXT datatype in SQL. Today, a user entered a comment that was about 1500
characters long and the dB truncated the msg.
What datatype
Hey ...
How do you do a query where all rows returned except in the case of
duplicates, based on a name column, in which only the first is returned.
So the query run against the following rows:
NameOrderNum
Fred21
Beth36
Fred76
Would return :
NameOrderNum
Fred
It's been a very long day (a very long year in fact :), and I'm severely
stumped on something I guess is dead easy.
Using CF 4.5.1 and SQL Server, I have a list of names like so (fields
firstname and lastname in a db):
John Smith
Jean Paul Gaultier
Jane Doe
I construct l
Whew . . . I'm still in one piece after that wind last night . . .
What's the best way to query a column in a table that has a comma delimited
list?
For example, in the query below: If B_xRef is a comma delimited list,
what's the most effecient way to find all the Table_b rows that contain the
I am getting the following SQL error:
Microsoft][ODBC SQL Server Driver][SQL Server]There are fewer columns in the
INSERT statement than values specified in the VALUES clause. The number of
values in the VALUES clause must match the number of columns specified in
the INSERT statement.
This doe
hi there.
say I have a database, mssql.
and I know 1 column that should be unique, and actually I have duplicates in
there.
is there a query that I can write that will select them all, find the
duplicates and remove
only 1 of the duplicate records?
thanks.
...tony
tony weeg
senior web applica
I know this is a little off list but I'm stumped, so if some guru out there could please give me a hand...I've got two tables, tblDates and tblEnt. tblEnt uses the intDateID field of tblDates. I am trying to pull the next 7 days where there is entertainment scheduled. tblEnt has a row for each day,
how would I use HAVING to select out where the difference between
reportsInDatabase and DistinctTimes is above 15%
im stuck and its just not clicking this morningthanks if you can figure
this out
select r.IpAddressNumber, v.VehicleIp,
Count(r.ReportId) as ReportsInDatabase,
Count(DISTI
is it true that we cannot use go in sql statements using cfquery?
--
tony
Tony Weeg
macromedia certified cold fusion developer
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
cool tool: http://www.antiwrap.com
[Todays Threads]
[This Message]
[Subscriptio
I have a question about how a relationship would be best modeled in SQL.
Currently I have a hiking website, which hosts trail reviews. People can add
their own comments which are associated with the hike.
For instance maybe I hiked snow lake on 12/1/05 and also 6/1/05. However, the
user rev
I want to verify email addresses that are entered into one of my apps.
Unfortunately I already inherited close to 100k email address. So I want to do
the following in SQL via a stored procedure so I can write the bad addresses
out to an error table. Need to check if there is an @ sign, if the TD
I have a ColdFusion app that is dynamically managing a SQL Server 2K
database. What I am running into is the need to change a column data
type - specifically an ntext data type. Anybody got any suggestions?
It appears that I cannot used ALTER TABLE/COLUMN with an ntext data
type, so what other
Tony Carcieri wrote:
> Hi all,
>
> Here's what I want to do:
> UPDATE tablename
> SET column = 0
> WHERE ID = ???
>
> I want to specify a range of numbers (like 100-200) and increment it by 2.
> So, 100, 102,104etc would only be updated and the rest wouldn't.
WHERE
ID BETWEEN 100 AN
Thanks Everyone! I appreciate the help!
Thanks,
Tony
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 7:26 PM
To: CF-Talk
Subject: Re: OT: SQL Question
Tony Carcieri wrote:
> Hi all,
>
> Here's what I want t
ON titleauthor.title_id = titles.title_id INNER JOIN sales
ON titles.title_id = sales.title_id
WHERE authors.au_id like ''8%''
GROUP BY authors.au_id, authors.au_lname
')
wg
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 03 Mar
SQL 7
does this still apply?
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:42 AM
To: CF-Talk
Subject: RE: OT SQL Question
SQL server ? use a format like this..
INSERT author_sales
EXECUTE
('
SELECT ''EXEC STRING
yeap actually simplier...
INSERT t1
SELECT a as a , b as c ,c as b
FROM t1
TEST b4 you do it
WG
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 14:44
To: CF-Talk
Subject: RE: OT SQL Question
SQL 7
does this still apply?
-Original
TECTED]
> Sent: Monday, March 03, 2003 8:36 AM
> To: CF-Talk
> Subject: OT SQL Question
>
>
> Can someone assist me with a quick SQL statement.
>
> I have a table with 3 columns: A, B, C (A would be the primary key)
> I need to swap the values in column B with the val
> Can someone assist me with a quick SQL statement.
>
> I have a table with 3 columns: A, B, C (A would be the primary key)
> I need to swap the values in column B with the values in column C
> and vice versa.
This should work with MS SQL assuming columns b and c are
the same data type:
UPDATE
Great. You did not provide your database or setup. I can only assume you
are working on a mainframe hitting DB2.
On Mon, 29 Jul 2002, Phillip B wrote:
> I need to do this and don't know where to start.
>
> Compare part of a part number in one table to another table. The part numbers look
>like
o:[EMAIL PROTECTED]]
Sent: 29 July 2002 21:27
To: CF-Talk
Subject: Re: OT: SQL question
Great. You did not provide your database or setup. I can only assume you
are working on a mainframe hitting DB2.
On Mon, 29 Jul 2002, Phillip B wrote:
> I need to do this and don't know where to start
Oh dear. Non-unique rows. Hmmm...
Unless its possible to do this with cursors (I know nothing about them), I'd say
you'd have to delete, then re-insert the data, or better yet add another column
to make it unique... ;)
David Cummins
Gavin Myers wrote:
>
> here's what i'm doing
>
> delete from
This hurts to look at. Is that the entire table? Or are there
additional fields that make those rows unique? If it's the entire table,
why do you have identical rows, and why do you want to retain them? If
there's more to the table, extend your 'where' clause to identify the
unique row that yo
Help SQL Server 7.0 gurus
I need to attach a SQL database to my SQL server. It was created on another
machine, and you know how MS SQL hates foreign DB's. It was suggested that
I try "attach_db", but all I get is the tables, not the data. I am NOT a
SQL guru. Please help. I will be worki
]
Subject: OT - SQL question
Hey ...
How do you do a query where all rows returned except in the case of
duplicates, based on a name column, in which only the first is returned.
So the query run against the following rows:
NameOrderNum
Fred21
Beth36
Fred76
Would return
y 03, 2000 10:45 PM
> To: [EMAIL PROTECTED]
> Subject: OT - SQL question
>
>
> Hey ...
>
> How do you do a query where all rows returned except in the case of
> duplicates, based on a name column, in which only the first
> is returned.
>
> So the query run agai
On 1/16/01, Gieseman, Athelene penned:
>
> INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date,
>Inv_No, Inv_Desc, ApprovedDate, Notes, Inv_Amount)
> values ('#Vendor#', '#Inv_GL#', '#Inv_City#', '#Inv_Dept#',
>'#Inv_Date#', '#Inv_No#', '#Inv_Desc#', '#ApprovedDate#', '#Not
That was it! Thank you!
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 4:18 PM
To: CF-Talk
Subject: Re: OT: SQL Question
On 1/16/01, Gieseman, Athelene penned:
>
> INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date,
&
On 1/16/01, Gieseman, Athelene penned:
>
> INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date,
>Inv_No, Inv_Desc, ApprovedDate, Notes, Inv_Amount)
> values ('#Vendor#', '#Inv_GL#', '#Inv_City#', '#Inv_Dept#',
>'#Inv_Date#', '#Inv_No#', '#Inv_Desc#', '#ApprovedDate#', '#Not
I'm sorry if this is off-topic, but I'm hoping for some help from people
who know more about SQL than I do ...
I have a hints'n'tips section on one of my sites, and it has 3 tables -
tblCategories, tblQuestions and tblAnswers. I want to have an index page
that lists the questions in their categ
Tony Weeg wrote:
> how would I use HAVING to select out where the difference between
> reportsInDatabase and DistinctTimes is above 15%
> select r.IpAddressNumber, v.VehicleIp,
> Count(r.ReportId) as ReportsInDatabase,
> Count(DISTINCT Time) as DistinctTimes, v.VehicleName, c.companyName
> fro
ieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 11:10 AM
To: CF-Talk
Subject: Re: ot: sql question
Tony Weeg wrote:
> how would I use HAVING to select out where the difference between
> reportsInDatabase and DistinctTimes is above 15%
> select r.IpAddressNumb
As far as I know you cannot.
- Original Message -
From: Tony Weeg <[EMAIL PROTECTED]>
Date: Wed, 22 Sep 2004 09:59:03 -0400
Subject: ot: sql question
To: CF-Talk <[EMAIL PROTECTED]>
is it true that we cannot use go in sql statements using cfquery?
--
tony
Tony Weeg
ED]>
> Date: Wed, 22 Sep 2004 09:59:03 -0400
> Subject: ot: sql question
> To: CF-Talk <[EMAIL PROTECTED]>
>
> is it true that we cannot use go in sql statements using cfquery?
>
> --
> tony
>
> Tony Weeg
>
> macromedia cer
John Munyan wrote:
> I have a question about how a relationship would be best modeled in SQL.
> Currently I have a hiking website, which hosts trail reviews. People can add
> their own comments which are associated with the hike.
>
> For instance maybe I hiked snow lake on 12/1/05 and also 6/
From: Umer Farooq [mailto:[EMAIL PROTECTED]
Sent: Fri 2/4/2005 12:54 PM
To: CF-Talk
Subject: Re: OT: Sql question
John Munyan wrote:
> I have a question about how a relationship would be best modeled in SQL.
> Currently I have a hiking website, which hosts trail r
Well.. oneway to do it is to create a new relationship table.. i.e
tblRelatedTrails
> relationID
> trailID
> relatedTrailID
and when doing a select for review you can do a sub select on the
relatedTrails table.. and use IN()
anotherway is to use the geo info of the trails.. and sele
I think you can write a UDF to validate email addresses. Here is link
http://vyaskn.tripod.com/handling_email_addresses_in_sql_server.htm
On Tue, 8 Feb 2005 12:55:42 -0600, Eric Creese <[EMAIL PROTECTED]> wrote:
> I want to verify email addresses that are entered into one of my apps.
> Unfortu
Thanks but I also need to try to test the TDLs like .com, .net, .uk...
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 1:19 PM
To: CF-Talk
Subject: Re: OT SQL question
I think you can write a UDF to validate email addresses. Here is
Eric Creese wrote:
> I want to verify email addresses that are entered into one of my apps.
> Unfortunately I already inherited close to 100k email address. So I want to
> do the following in SQL via a stored procedure so I can write the bad
> addresses out to an error table. Need to check if th
Hello All,
I'm trying to use xp_cmdshell to run a dts job. This is what I have:
exec master..xp_cmdshell "DTSRun /S ServerName /U Username /P Password /N
[Load pr_Labor Table]"
but getting this error:
Error string: The specified DTS Package ('Name = '[Load pr_Labor Table]';
ID.VersionID =
> I have a ColdFusion app that is dynamically managing a SQL Server 2K
> database. What I am running into is the need to change a column
> data type - specifically an ntext data type. Anybody got any
> suggestions?
>
> It appears that I cannot used ALTER TABLE/COLUMN with an ntext data
> type,
If you're talking about moving a database, a coworker ran into this
recently. Here's what he found out, verbatim: (in other words, your mileage
may definitely vary, no I haven't tried it, etc.)
---snip
- From EM (Enterprise Manager), perform a backup of
>>Here is where the problem comes in. If the destination server does not
have
the same DATA directory location and structure as the source server, you
will receive an error when trying to perform a restore from within EM. The
error indicates that we should use the 'MOVE' option. If you receive
Thanks for the excellent information. I am off to do battle with M$ SQL...
Nick
[EMAIL PROTECTED]
- Original Message -
From: "Darryl Davidson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 24, 2000 11:13 AM
Subject: Re: slightly OT - SQL question
I am having a hard time finding the right syntax in SQL. Backend Database is
SQL Server 7
What I am trying to acomplish. I have some duplicate records that I need to
get rid of, the problem is that all these records already have a unique key,
but the rest of the fields are the same. I was hoping
danke!
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 2:12 PM
To: CF-Talk
Subject: Re: OT SQL question
Eric Creese wrote:
> I want to verify email addresses that are entered into one of my apps.
> Unfortunately I already inh
egory, HNTQuestion.QuestionShort
Bob
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 5:33 PM
To: CF-Talk
Subject: OT: SQL Question (Access)
I'm sorry if this is off-topic, but I'm hoping for some help from people
who know more about SQL than I
53 matches
Mail list logo