Selecting rows with repeating values in one column

In SQL Server R2 this query: SELECT id, code, sequence_number FROM mytable returns this data: id code sequence_number 1 381 0 2 381 1 3 382 0 4 382 1 5 383 0 6 383 1 7 384 0 8 384 1 9 384 1 10 385 0 11 385 1 12 386 0 13 386 1 14 387 0 15 387 1 ...

Message posted on the May 29th, 2013 - 9:33 AM ET

1010data’s Big Data Analytics Platform Sees Significant Growth in 2012

Company Adds to Its Management Team, Signs More Than 80 New Customers, and Now Hosts More Than 11.5 Trillion Rows of Data.

Press published on the March 19th, 2013 - 7:00 AM ET

ExactTarget Launches Audience Builder, Enables Marketers to Identify Target Audiences in Real Time

ExactTarget Audience Builder Provides Industry’s First Integrated Solution to Consolidate Millions of Rows of Data to Create a Common View of Each Consumer in Real Time.

Press published on the September 13th, 2011 - 1:30 PM ET

NHK and Mitsubishi Electric Corporation Successfully Develop World's First HEVC Encoder for 8K "Super Hi-Vision"

NHK (President: Masayuki Matsumoto) and Mitsubishi Electric Corporation (President & CEO: Kenichiro Yamanishi) have jointly developed the world's first HEVC1) encoder for 8K ultra HDTV "Super Hi-Vision" ...

Press published on the May 9th, 2013 - 1:00 AM ET

Incisive Releases Xcellerator 2.0 and Announces Diff Interactive 1.5

Upgraded Solutions Deliver New Features for More Accurate Spreadsheet Analysis and Added Productivity.

Press published on the July 9th, 2012 - 5:55 AM ET

RD&IP Receives Patents for Reducing Manufacturing Cost in Making LCD and OLED Televisions

RD&IP, L.L.C. today announces it has developed technology for making televisions with organic transistors and diodes using printing process. RD&IP’s technology is aimed to significantly reduce the manufacture cost ...

Press published on the October 25th, 2011 - 1:00 PM ET

MISUMI USA Showcases Linear Guides at ATX Canada

Exceptionally wide variety of product models and rapid delivery times allow design engineers to select the right linear motion solution for small, medium, heavy and ultra-heavy loads..

Press published on the May 14th, 2013 - 7:15 AM ET

Actian Announces Availability of Vectorwise 3.0 for Getting Fast Answers from Big Data

The latest Vectorwise offering provides high-performance integration for Hadoop.

Press published on the March 19th, 2013 - 4:00 AM ET

Bug#656281: Multiple Workspace Switchers with multiple Panels ignores number of rows

Package: xfce4 Version: 4.6.2 When using multiple panels, each with their own workspace switcher, the number of rows configured on one of the switchers is not honoured after logout/login. For example, if you configure two workspace switchers to ...

Message posted on the January 17th, 2012 - 7:10 PM ET

Help - hiding multiple sets of rows based on two different cells

Please help. I have two cells on say Sheet 1 (cell C9 and cell C11). If cell C9 < 0.01, then I want to hide rows 56:64 on Sheet2. At th same time, if cell C11 < 0.01, I want to hide rows 65:78 on sheet 2). have compiled something based on ...

Message posted on the June 12th, 2012 - 4:23 AM ET

Shifting rows to sheet2 using Macro

Hi, I am trying to use macro to shift cells from one sheet to anothe once the status of the tasks is changed to completed. I want the program to do the following Look in column U to find the status completed. Then Select the complete row, Copy it ...

Message posted on the August 10th, 2012 - 12:53 AM ET

how to insert serial numbers to rows?

suppose i have a worksheet in which i have some data in col B with header on B1 there are blank rows in between data.i want to give serial numbers t col A irespective of the fact that whether it has data on its right sid or it is a blank one i put ...

Message posted on the April 13th, 2012 - 10:52 AM ET

Quickly count used rows?

Suppose I have a 60 x 9 cell range that is initially empty. Users will be able to fill data into each row. Is there a quick and efficient method to count how many rows contain data?? (A row is considered to contain data if any one more cells of ...

Message posted on the September 18th, 2012 - 4:48 AM ET

Move data from first 7 rows from one column A into multiple Columns then the next 7 rows

Hello, I am trying to figure out if it is possible to code a VBA macro (and if so how to do it) to take the first 7 rows of data from Column A and move it to the first row of Columns B,C,D,E,F,G,H and then proceed to the next 7 rows in Column A and ...

Message posted on the January 7th, 2013 - 1:47 PM ET