strange result when using the into statement 
Author Message
 strange result when using the into statement
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.
thanks for any help Michael.


Sat, 31 Jul 2004 04:21:54 GMT
 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



Sat, 31 Jul 2004 06:52:25 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Strange result with this SQL statement...

2. Stranger Results of Select Statements

3. Join to view that uses COALESCE returns strange results with NULLS

4. Strange query-result when accessing ex2k using exoledb

5. strange select results when NOT IN used

6. Using LIKE operator with MDB causes strange results

7. Strange results using remote views to access db2 database

8. Strange result using InputB() - need help!

9. Strange query results using CONVERT?

10. Strange Problem using SQL statement in ISAPI Extension

11. Strange Problem using SQL statement in ISAPI Extension

12. strange beheviour with select statement using ado/paradox


 
Powered by phpBB® Forum Software