msql compare same column
BEGIN
Declare @req varchar(200),
Declare @maxred varchar(200)
set @req=(select mycolumn1 from table where )
set @maxreq=(select mycolumn1 from table where)
if(@req<=@maxreq)
THEN
update
END
I have a table column name, mycolumn1.
what I would like to do is compare. if the column name changes then update 1 in another column else 0
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Tell you what, please re-ask your question, providing sample data for the 'before' and 'after' of what you're trying to pull off, and using explicit column names instead of 'another column' and 'the column'.
ASKER
select statements will check column
@req>>mycolumn1 @maxreq>>mycolumn1 additional column value(blank)
mydata mydata 1
mydata mydata 0
mydata mydata 0
newdata newdata 1
newdata newdata 0
newdata newdata 0
@req>>mycolumn1 @maxreq>>mycolumn1 additional column value(blank)
mydata mydata 1
mydata mydata 0
mydata mydata 0
newdata newdata 1
newdata newdata 0
newdata newdata 0
ASKER
Every time it finds a different row that is new it will add 1.
ASKER
I got it myself thanks anyway.
declare @boothTable table (BoothNameID varchar(200),RownameID varchar(20), ProductID varchar(6))
insert into @boothTable
SELECT distinct BoothName,
rowid,
product
FROM tableM
ORDER BY rowid,BoothName
DECLARE Booth CURSOR FOR
SELECT BoothNameID,
RownameID,
ProductID
FROM @boothTable
--order by VendorID,BoothNameID
--ORDER BY BoothNameID, SequenceID
--ORDER BY Grouper,sequence
OPEN Booth
FETCH NEXT FROM Booth INTO @BoothNameID, @RownameID, @ProductID
WHILE @@FETCH_STATUS = 0
BEGIN
IF @BoothNameID = @BoothNameID2
SET @Seq = @Seq + 1
ELSE
SET @Seq = 1
-- This is executed as long as the previous fetch succeeds.
UPDATE table
SET WebSeq = @Seq
WHERE Boothname = @BoothNameID and RowID=@RownameID and Product = @ProductID
-- order by rowid asc
SET @BoothNameID2 = @BoothNameID
FETCH NEXT FROM Booth INTO @BoothNameID, @RownameID,@ProductID
END
CLOSE Booth
DEALLOCATE Booth
declare @boothTable table (BoothNameID varchar(200),RownameID varchar(20), ProductID varchar(6))
insert into @boothTable
SELECT distinct BoothName,
rowid,
product
FROM tableM
ORDER BY rowid,BoothName
DECLARE Booth CURSOR FOR
SELECT BoothNameID,
RownameID,
ProductID
FROM @boothTable
--order by VendorID,BoothNameID
--ORDER BY BoothNameID, SequenceID
--ORDER BY Grouper,sequence
OPEN Booth
FETCH NEXT FROM Booth INTO @BoothNameID, @RownameID, @ProductID
WHILE @@FETCH_STATUS = 0
BEGIN
IF @BoothNameID = @BoothNameID2
SET @Seq = @Seq + 1
ELSE
SET @Seq = 1
-- This is executed as long as the previous fetch succeeds.
UPDATE table
SET WebSeq = @Seq
WHERE Boothname = @BoothNameID and RowID=@RownameID and Product = @ProductID
-- order by rowid asc
SET @BoothNameID2 = @BoothNameID
FETCH NEXT FROM Booth INTO @BoothNameID, @RownameID,@ProductID
END
CLOSE Booth
DEALLOCATE Booth
>Every time it finds a different row that is new it will add 1.
Since I see three rows of 'mydata', how do you determine the ordering of those three, so I know which one to add 1? Is it just the position within the table, or is there a column somewhere that dictates the order?
Since I see three rows of 'mydata', how do you determine the ordering of those three, so I know which one to add 1? Is it just the position within the table, or is there a column somewhere that dictates the order?
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER