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 |
|
happydragon
Starting Member
2 Posts |
 Posted - 2007-11-02 : 09:07:43
|
I am having this problem i have a table when i try to select a distict value from model and inclued feilds link & Tariff i get a duplicats due to the fact that the model is available on diffrent tariffs.i have a view which has all the models in it which was created using the select distinct and i get no dups only when i add link and tariff do i get the dups, their are other feilds that also create this probwhat i want is to select the first model keep that as distinct and add the other information without dups i have try most things including creating the view and the using dreamweaver to to filter the dups out but that had no luckTable info highlighted fieds have information that cause the dups dbo.###.ProductID, dbo.###.Category, dbo.###.Manufacturer, dbo.###.Colour, dbo.###.Handset_Description, dbo.###.Tariff_Minutes, dbo.###.Tariff_Texts, dbo.###.Tariff_Cost, dbo.###.Network, dbo.###.Phone_Price, dbo.###.Promotional_Header, dbo.###.Cashback_amount, dbo.###.Promotional_Text, dbo.###.Image_URL, dbo.###.Dp_link_URL, dbo.###.Add_To_Basket_URL, dbo.###.Model,any advice Cyber Cauldron |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-02 : 09:26:59
|
| It's a requirements issue.Which tariff do you want for the model. Once you've decided that the problem goes away - without it there is no solution.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
happydragon
Starting Member
2 Posts |
Posted - 2007-11-02 : 09:59:53
|
| This is a soloution not all models have the same tariffs thanksCyber Cauldron |
|
|
|
|
|
|
|
|
Problems with Select distinct