Question

  • Thread starter Thread starter joey
  • Start date Start date
J

joey

I am a first time user on access and trying to copy and paste the SQL
content in an ASP file; however, my output has duplicate content. Is there a
comment used in the SQL I can use to get one time content.

Please advise.

Thanks Joey...
 
Yes, there is. In fact, there are many possibilities. However, as you
didn't post nothing about your actual SQL query, tables design and exemple
of data, it's hard to tell you anything more. In your case, probably that
the use of SELECT DISTINCT or of a Group By instruction will do it but there
is also the possibility of some kind of error in your JOIN statements.

Also, this newsgroup is about ADP and its relation with SQL-Server. If your
question is strictly about programming in T-SQL on SQL-Server, a newsgroup
such as m.p.sqlserver.programming is probably better suited for this kind of
questions. For classic ASP, there are the newsgroups m.p.inetserver.asp.db
and m.p.i.asp.general and for ASP.NET (not the classic version), there are
many newsgroups in the m.p.donet.* and the m.p.donet.framework.* hierarchies
dealing with databases and sql statements.
 
Back
Top