Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-01 : 11:13:04
|
| Newbie writes "I have query that i am running to retrieve data from several tables using inner and left joins, it is returning duplicates, Distinct is not working , i just wondered is there anyway around this...i have copied out to excel and created an IF function to elimate where the next row was the same as the previous row.i just wondered if there was a more efficient way of doing this in SQL query analyser" |
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2007-02-01 : 12:06:14
|
| to say the solution...you need to tell what is your table structures and how you are writing the query |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-01 : 14:19:38
|
| Is it datetime columns that are causing your problem?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
SQl Select returning duplicates