Using SQL Server, how would I define a query to return ranges of ID's
(primary key) where a tinyint field was not true?
I'm looking for any ranges (eg; 12202 - 12249 and 14477 - 15225) where that
tinyint field is 0. I'd like to specify a minimum number of records in that
range, but it's not absol
I'm using Aliases
SELECT A.ResortName, B.Year, B.News
FROM Resorts A, NewFor B
WHERE B.ResortID = A.ResortID
ORDER BY B.Year
hehehehe
>From: "Jim McAtee" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT: SQ
I could use a bit of help with what I'm guessing is a fairly easy query.
I've got the following:
Tables:
Resorts
NewFor
Resorts Table:
ResortID pk
ResortName
NewFor Table:
NewForID pk
ResortID fk
Year
News
In the NewFor table I've got news for 1999, 2000, 2001, etc. for most (but
not all resor
I don't know if any of you know how to do it but I'm trying to get the SQL
query pasted below to include the two dates, at the moment it doesn't return
data from the two dates specified. ie It returns queries starting Jan 02 and
ending 19 Feb
:-(
SELECT DateAdded, EmailA
FROM
4 matches
Mail list logo