strange result when using the into statement
Quote:
> Has anyone ever been using query analyzer and you get differant
> results when you add the into clause when you use the select
> statement.
> I wrote a query to read out a set of random numbers that had not been
> used and when I had just the select part working it was fine. when I
> added the into portion I got the same record over and over again.
How about posting the actual query and the CREATE TABLE statements
for any tables included in the query? Sample data in INSERT statements
is good too.
--
Erland Sommarskog, Abaris AB
SQL Server MVP
