I know I have done this before but for the life of me I can remember how'

When I run the query below it loops and loops, how do I make it appear just
once - missing something but brain freeze has taken over aaaggghhh....

select [T_GIFTCARDS].[M_CARDNUMBER], [T_GIFTCARDS].[M_SERIALNO],
[transaction].[M_GIFTCARDNO], [transaction].[req_login_time]
from [T_GIFTCARDS], [transaction]
where req_login_time between '27 September,2004' and '28 September, 2004'

your help much appreciated

What do you mean by "The Query loops" ? A query doesn´t loop around on
its own, actually it doesn´t loop at all.

same information in rows 1-84 shows up in query analyzer then row 85 shows
row 1 again then so on until row 829227262525.......or until system stops

Show quoteHide quote

=?Utf-8?B?SXZv?= (I**@discussions.microsoft.com) writes:
You have two tables in your WHERE clause, but there is no condition for
joining them, which means that you get call possible combination of
rows. If there are 1000 rows in T_GIFTCARDS, and there are a million
rows in transactions for the given time range, the query will produce
one milliard rows.

Erland Sommarskog skrev:


That would be one 'billion' in english, or are there even differences
between british and american english? (Not to mention Erland's swedish
english ;)  )

    /impslayer, aka Birger Johansson

impslayer (impsla***@hotmail.com) writes:
See http://www.m-w.com/dictionary/milliard.

However, both in British and American English, they capitalise "British",
"American" and "English". :-)

But maybe we should table this discussion before it goes too far. (Now,
let's see how many how get *that* one!)

Erland Sommarskog skrev:

When will I ever (EVER!) learn to check stuff out before I make a
post???
Had no idea 'milliard' existed in English (sic!), and was hoping I'd
clarify that you meant 'billion'... Definitely no cheap shot, I promise
   /impslayer, aka NoBrainPoster

impslayer (impsla***@hotmail.com) writes:
Rest assured that if I ever say "billion", I mean a real big billion, and
not the wimpy billions they have over there!

Whats Wrong with the Query?
TSQL Debugger Oddity
Newbie:UNION with SELECT TOP
store image
DB design question.