"Richard Morey" <rwmorey71@hotmail.com> wrote in message
news:eQmt1rOwDHA.2520@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I am at a total loss as to how to accomplish a task..
>
> I have one table with two sets of values.. like this
>
> 1000,september
> 1234,september
> 1566,september
> 2000,october
> 2010,october
> 2022,october
>
> and a second table with one set of values
>
> 1000
> 1234
> 1000
> 1566
> 1000
> 2000
> 2010
> 2011
> 2022
> 2000
> 2010
>
>
> What I would like to to is change the values in table 2 so that all the
> "Septembers" (represented in this example by 1000,1234,1566) change to
1000
> and then delete the other values (1234,1566) from table 1..
>
> I can't do this simply by # because this scenerio comes from a data
> conversion routine and the numbers wont' be known until "run time"..
>
> So I need a query that can change the values in the second table based on
> the first table and then delete the duplicate values in the first table..
>
> As I said, I'm at a total loss as to where to even start..
>
> Thanks
>
> Rich
>
>

"Richard Morey" <rwmorey71@hotmail.com> wrote in message
news:er1OOJPwDHA.2452@tk2msftngp13.phx.gbl...
> Okay, I got this far..
>
> set @varSEASON = 'OCT-MAY'
>
> UPDATE tablerentals SET SEASON = (SELECT TOP 1 SEASON FROM
> lookupTableRentalSeasons where seasonname = @varSEASON) where season in
> (select season from lookupTableRentalSeasons where seasonname =
@varSEASON)
>
> Is there any way in the query analyzer to select a dataset and iterate
> through it and perform the above for each record, obviously setting the
> variable to the value each time.. ?
>
> Rich
>
> "Richard Morey" <rwmorey71@hotmail.com> wrote in message
> news:eQmt1rOwDHA.2520@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I am at a total loss as to how to accomplish a task..
> >
> > I have one table with two sets of values.. like this
> >
> > 1000,september
> > 1234,september
> > 1566,september
> > 2000,october
> > 2010,october
> > 2022,october
> >
> > and a second table with one set of values
> >
> > 1000
> > 1234
> > 1000
> > 1566
> > 1000
> > 2000
> > 2010
> > 2011
> > 2022
> > 2000
> > 2010
> >
> >
> > What I would like to to is change the values in table 2 so that all the
> > "Septembers" (represented in this example by 1000,1234,1566) change to
> 1000
> > and then delete the other values (1234,1566) from table 1..
> >
> > I can't do this simply by # because this scenerio comes from a data
> > conversion routine and the numbers wont' be known until "run time"..
> >
> > So I need a query that can change the values in the second table based
on
> > the first table and then delete the duplicate values in the first
table..
> >
> > As I said, I'm at a total loss as to where to even start..
> >
> > Thanks
> >
> > Rich
> >
> >
>
>